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:

http://vidmar.net/weblog/archive/2008/06/05/save-sql-query-results-with-column-names-in-msssms.aspx

Answer 1

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.

Answer 2

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.

Answer 3

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