SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 02:19 PM
| |||
| |||
 Re: Createa table like a existing table? 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/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx      |
|
02-29-2008, 02:19 PM
| ||||
| ||||
| Re: Createa table like a existing table? On Tue, 27 Dec 2005 08:13:25 +0000 (UTC), Erland Sommarskog <esquel@sommarskog.se> wrote: >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. 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. |
Linear Mode
