How to list all columns of a given sql query

Question

is there an easy way to get a list of all columns of a SQL query? They are listed in the header of the results window of SSMS but I can't copy them.

Thanks in advance.

EDIT:

sorry, I found it myself after a little googling:

codingbadger · Accepted Answer · 2010-09-23 09:42:13Z

4

Go to Query -> Query Options and check the following box alt text

answered Sep 23, 2010 at 9:42

codingbadger

44.3k13 gold badges99 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AdaTheDev · Accepted Answer · 2010-09-23 09:43:18Z

2

If you change to Results To Text, then you can copy them.

To save actually executing the full query just to get the column names, you could also do:

SET FMTONLY ON;
SELECT * FROM SomeTable;

This will just return the metadata about the columns the query returns. Saves waiting around if the query is meaty.

answered Sep 23, 2010 at 9:43

AdaTheDev

148k28 gold badges215 silver badges204 bronze badges

Ralf de Kleine · Accepted Answer · 2010-09-23 09:42:15Z

0

Change the result window to 'Results to text' instead of 'Results to grid'.

This can be done by clicking of the on of the Icons above the query window. It looks somewhat like a notepad icon.

answered Sep 23, 2010 at 9:42

Ralf de Kleine

11.8k5 gold badges50 silver badges89 bronze badges