Createa table like a existing table?

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

SSG (ssg14j@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

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

>SSG (ssg14j@gmail.com) writes: 
>
>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.