I was in two minds about whether to blog about this as I’m sure many people know this already! What the hell! I’m not embarrassed to admit I don’t know everything.

Even the most casual user of SSMS knows that you can drag any database, table or column from the object explorer to the editor.

drag_column_sql_server_management_studio_ssms

The object name that is dragged into the editor will get inserted into your script. A simple and handy timesaver!

sql_server_management_studio_editor

But did you know the same applies to the columns folder under each table? Drag and drop the columns folder into the editor and all the column names, from the relevant table, will be inserted into your script.

sql_server_management_studio_editor_all_columns

I dread to think of the time I’ve wasted dragging each column individually! Now there’s another reason not to use SELECT * in your scripts! Do you know of any more SSMS timesaving gems?