Tuesday, April 7, 2015

See how references may be crafted in MSSQL in your particular version of MSSQL.

Right-click on an existing table in SSMS and pick...

Script Table as > CREATE To > New Query Editor Window

 
 

This should spit up some legit SQL for making references. What you can get away with in SQL Server 2012 and SQL Server 2005 differ!

 
 

Addendum 1/28/2020: Make a CREATE TABLE script from a database table in SSMS with this trick too. Right-click on a table in the Object Explorer.

No comments:

Post a Comment