Sql- Column Headers

[Guest_imported]

How do you take the column headers off in SQL

 

[tlbroadbent]

Depends on how you are running the query. In SQL 2000 Query Analyzer, open Tools | Options. Click on the Results tab and uncheck Print column headers. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Giddygoat]

Can this be done programmatically, like SET NOCOUNT removes the rows affected output, is there anything to remove the column headers?

 

[tlbroadbent]

I know of no way to suppress headers with a SQL command. The client tool must suppress headers as noted previously regarding QA.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm