SQL Server Avoid Typing Field Names Tip

After 3 years of using SQL Server I stumbled across this shortcut for writing SQL Statements. How many times have you had to write a SQL statement that contains 80% of the fields of a table, or maybe an insert statement where fields are specified and you need to type all of them out. You get the drift typing field names suck. The easy way to get around this in SSMS (SQL Server Management Studio) is:

1. Expand your Tables of a Database Working on
   
2. Drill down on the tables
   
3. Pull the Columns root (Lack of a better term) over to the Query window
   
4. All the columns will get pulled over in text

to expand your tables within a Database