Articles → SQL SERVER → Set Fmtonly In SQL ServerSet Fmtonly In SQL ServerIn this article, we will discuss the set fmtonly in the SQL server.Purpose The Set Fmtonly When On Returns A Rowset With Column Names And Without Any Data Rows.Example Consider the following example: -SET FMTONLY ON; select * from sys.objects SET FMTONLY OFF; select * from sys.objectsOutput Posted By - Karan Gupta Posted On - Saturday, October 28, 2023 Query/Feedback Your Email Id** Subject* Query/Feedback Characters remaining 250**
SET FMTONLY ON; select * from sys.objects SET FMTONLY OFF; select * from sys.objects
Query/Feedback