Blog

Copy Table Schema with SQL Server Management Studio

December 28, 2009

Quick way to copy the table schema using SQL Server Management Studio:

1. Right-Click table to copy
2. Script table as
3. CREATE To
4. New Query Editor Window
5. Find & Replace all instances of the table you are copying with the table you wish to create

NOTE: Pay attention to any Primary Key and Foreign Key indexes listed in the SQL script. They may require updating as well.