Get column names(parameter names) using Object Explorer in SSMS
Template Explorer contains lots of SQL Example Scripts maybe you want to create.
Situation
I want to type column tables from the table easily.
Typing all columns manually is not really efficient. (Maybe that's why you type "*" ).
Copy and paste column names using Object Explorer
New query.
Maybe you want to put "*" in there. But please wait.
Open Object Explorer and expand to "Columns"
Now, drag and drop that "Columns" to SQL Query Window.
Voila, all column names pasted to Query Window.
Copy and paste Parameters of Stored Procedure using Object Explorer
You can also get parameters of stored procedure with the same method.
drag and drop "Parameters" from Object Explorer to Query Window.
Parameters will be there.
What about the other objects?
As you can imagine, most of the objects from Object Explorer can be copied to Query Window.
But there's bug to copying "Constraints". SSMS might die when you try to drag and drop "Constraints" to Query Window.
