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