Copy only column header from resultset in microsoft sql server management studio

Question

I want to copy only 'Column Headers' from the result set in Microsoft Sql Server Management Studio but I didn't find any option. Same option is there is Oracle SQL server management. I googled about it but didn't find any thing that would help me so wanted to check if there a way to do this

Answer 1

Run your query without any result-set using select * from tablename where 1=2

then use "Copy with Header".This is the only way to copy only columns header.

Answer 2

Instead of result into grid please use Result to text. Result to Text - Ctrl+3

Hope this helps.