Good sql editor that will fill in field descriptions from the table explorer.

Does anyone know of an easy way in Sql Server2008 to fill in the field descriptions from a table, i.e. a drag and drop capability?   I'm using temp tables in my stored procedure and I was looking for a faster way of getting the field description into my temp table declaration, i.e.,  field1 varchar(10),  field2 int,  field3 numeric (18.0) , etc.
Mike JohnsonBusiness Inteligence DeveloperAsked:
Who is Participating?
 
ste5anConnect With a Mentor Senior DeveloperCommented:
Right-click in SSMS on your table and select Script Table as / CREATE To.
0
 
Narender GakkaAWS / DevOps / Cloud ConsultantCommented:
I think SQL Prompt from Redgate would help in this regard.

Download the freetrial and give it a go
http://www.red-gate.com/products/sql-development/sql-prompt/
0
 
Mike JohnsonBusiness Inteligence DeveloperAuthor Commented:
Thanks guys...
0
All Courses

From novice to tech pro — start learning today.