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.


Leave Your Comment

Your email address will not be published. Required fields are marked *

about me

An information technology professional with twenty four years experience in systems administration, computer programming, requirements gathering, customer service, and technical support.