Creating Empty duplicate table

[joepeacock]

Hello,

I am trying to duplicate a project and I need some help here. What I am trying to do is duplicate Table A, which has 50 or so columns and 30,000 or so records. I need table B to have identical columns, with all of the same datatypes, default values, indexes, increment seeds, etc. as Table A, but start with 0 records. I can't just duplicate the entire table, then delete the records, because I need the next ID to start at 1, not at 30,001. Please let me know how to go about this.

Joe

 

[tlbroadbent]

Do you have SQL Enterprise Manager (EM) and Query Analyzer (QA)? If so the follwoing wil work.

Open the database in EM. Right click the table. Select All Tasks | Generate SQL Script. Click on the Options tab. Select all the options under Table Scripting Options. Click on OK to generate the script o a file or click the Geneal tab and the Preview button.

If you generate to a file, load the file into QA. If you chose Preview, copy the preview to the clipboard and paste in a QA window. Change the table name. Run the query to create the table. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[joepeacock]

Thanks for the suggestion. What I wound up doing was setting up a DTS packet with a Transfer Object and just told it to copy the tables I needed with all of the structure in place, but no data. So simple...

Joe

 

[MaxZak]

Create a task with a "Copy SQL Server Object Task", select the source database, destination database(a different one), the table to copy (uncheck "copy all objects&quot, uncheck "Copy Data", uncheck "Use default options" and click "Options" to select what you want to copy (users, roles, indexes, triggers, keys, ...)

 

[joepeacock]

Yeah... that's what I did... it worked...

Sorry, maybe I wasn't clear.