Copy Table Structure

• David Wilson-432897

  SSC Enthusiast

  Points: 176

  More actions

  June 6, 2007 at 8:36 am

  #179150

  I am coming to SQL Server from Access, where just about everything you need is in the GUI, so natch I am having some problems 🙂

  what about copying a table structure to a new table in the same database?

  any help will be appreciated

• Carlos Pereyra

  Ten Centuries

  Points: 1039

  More actions

  June 15, 2007 at 3:10 pm

  #713403

  If you just want to duplicate the table structure and not the data:

  select * into <newtable> from <sourcetable> where 1 = 0

  ---

  Regards,

  Carlos

• bledu

  SSChampion

  Points: 12335

  More actions

  June 28, 2007 at 4:39 pm

  #716020

  Carlos' method is probably the quickest but you could create a CREAT TABLE script

  In SSMS right click on the table > Script Table as.. > Create To..

  You can then change the name of the table in the create script and then run it in query window.

  This way it helps you to understand how a table is created etc

  ---

  Everything you can imagine is real.