Createa table like a existing table?

[SSG]

Hai all

I am new to SLQ server. Can anyone tell me how to create a table that
should look like a existing table fields....

thanx

[Erland Sommarskog]

SSG (ss****@gmail.com) writes:

I am new to SLQ server. Can anyone tell me how to create a table that
should look like a existing table fields....

You can do "SELECT * INTO newtbl FROM tbl WHERE 1 = 0". Beware though
that constraints, indexes and triggers are not copied. If you want that
you are better off scripting the table, which you can do by right-clicking
the table in the Object Broswer in Query Analyzer. Even better, have all
your source code under version control. Then copying is even easier.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Steve Jorgensen]

On Tue, 27 Dec 2005 08:13:25 +0000 (UTC), Erland Sommarskog
<es****@sommarskog.se> wrote:

SSG (ss****@gmail.com) writes:

I am new to SLQ server. Can anyone tell me how to create a table that
should look like a existing table fields....

You can do "SELECT * INTO newtbl FROM tbl WHERE 1 = 0". Beware though
that constraints, indexes and triggers are not copied. If you want that
you are better off scripting the table, which you can do by right-clicking
the table in the Object Broswer in Query Analyzer. Even better, have all
your source code under version control. Then copying is even easier.

Also note that in most cases where you would want to copy a table's design
within the same database, you'd probably be better off doing more
normalization instead.