|
Home > Archive > Microsoft SQL Server forum > December 2005 > Createa table like a existing table?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Erland Sommarskog 2005-12-27, 3:23 am |
| 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
| |
| Steve Jorgensen 2005-12-27, 3:23 am |
| 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.
|
|
|
|
|