How to not display the column header in the output of a MS SQL Script?

If you are using the SQLCMD utility and want to avoid or suppress the column header in the output of SQL Script. You can do it just by setting the Variable  SQLCMDHEADERS to -1  by default its 0

 

Setting the variable to -1 suppresses the column header in the output. Also if you want the Column header to be inserted after a certain number of records, you can do so by setting the variable to that value.

 

Eg.

:SETVAR SQLCMDHEADERS -1   (will suppress the column header)

:SETVAR SQLCMDHEADERS 10  (will insert column header after every ten records)