Adding All Columns In A Table To A Query [Easy]

I wanted to share this quick tip with you on how to add a list of all the columns in a table to your query window in SQL Server Management Studio. This is the easiest way I know!

1. Expand the Object Explorer to show the table that you want to add the columns for.
       
2. Select the Columns folder on to your query window.
       
3. Drag the whole folder on to your query window and just drop it where you want it. That’s it!