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!
- Expand the Object Explorer to show the table that you want to add the columns for.
- Select the Columns folder on to your query window.
- Drag the whole folder on to your query window and just drop it where you want it. That’s it!