Saturday, February 25, 2012

Copy a table

Can I copy a table from on DB to another - I only want to copy the column
names not the Data
What tool or how should I do this
Thanks
ChrisWhy don't you generate the CREATE TABLE script, and then create the empty
table?
There are lazy ways to do this, e.g. SELECT * INTO newdb.dbo.tablename FROM
OldTable WHERE 1 = 2; but this leaves out many other important things, like
indexes and constraints.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:BCD66035-F4BB-46B4-8FCC-4A4D12828918@.microsoft.com...
> Can I copy a table from on DB to another - I only want to copy the column
> names not the Data
>
> What tool or how should I do this
> Thanks
> Chris

No comments:

Post a Comment