Every once in a while I come across some “hidden” and nice features in SSMS. One of them is really nice if you want to print all columns names of a table.
So instead of writing all the column names by hand you could follow these easy steps.
– Open SSMS
– Expand you database
– Expand your table
And then drag the folder called “Columns” to your query window