ansaurus

Question

Create Table by Copying Structure of Existing Table

Answer 1

+4 A:

like this, however this will not create indexes and constraints

select * into Drop_Centers_Detail
from Centers_Detail
where 1 = 0

SQLMenace 2010-05-19 18:06:02

Supporting documentation - INTO clause: http://msdn.microsoft.com/en-us/library/ms188029.aspx

OMG Ponies 2010-05-19 18:08:14

be sure to read the "Limitations and Restrictions" in the link given by @OMG Ponies. You won't get computed columns, indexes, constraints, or triggers from the source table.

KM 2010-05-19 18:12:43

Thanks for the answer and the info. It worked. Just out of curiosity is there a way to copy an existing table and preserve its indexes, constraints, etc.?

2010-05-19 18:34:11

you will need to script it out in that case or you can use SMO (http://msdn.microsoft.com/en-us/library/ms162169.aspx)

SQLMenace 2010-05-19 18:44:37

Answer 2

+1 A:

In Sql Server Managment Studio, right-click your existing table and select Script Table as > Create to > New Query Editor Window. This will give you a better starting script that you can use as the base for your new schema.

SethO 2010-05-19 18:08:00

Thanks for the info.

2010-05-19 18:38:41

Answer 3

A:

1) I would suggest generating a create script from the table you want to copy, and then run that on your destination database.

2) Write a Insert statement in another SQL Query window to import that data

Insert Into Database1.Table1(Field1, Field2) Select Field1, Field2 From Database2.Table

dretzlaff17 2010-05-19 19:53:17

ansaurus

tags:

views:

answers:

Create Table by Copying Structure of Existing Table

related questions