How can you copy a table in SQL Server 2000. All I want is to duplicate the structure of a pre-existing table in the same database. I don't care if I don't get the data. It has to be easy to do but I can't find anywhere in the help where they tell you how to do it?

If you don't care about the data, you could generate a script to create the table, preview it, edit it to change the name, copy it to the clipboard, paste it into QA then execute it.

You could also use the proprietary, non standard, SELECT ... INTO construct which will create a new table from a source table and populate it with the data from the source. Add a WHERE clause with a predicate that evalutes to FALSE to create the structure without copying any rows.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Try this

select * into Table2 from Table1 where 1=2

prakash

Thought you might like a graphical way as well. If you have access to Enterprise Manager, you can also do it this way. Open EM and right click on the server that holds the database.

Click on All Tasks, then Import Data. This will bring up the DTS Import/Export wizard. Click Next once.

Choose your Data Source server, then database and click next. Choose the destination server, and the database (should be the same as previous if you are copying to same location). Click Next. Select Copy table(s) and view(s) from the source database and click Next.

In the Table(s) and View(s) list, scroll down until you see the table you want to copy and check it. Once you check it, you will see the destination box right next to it fill. In order to not overwrite the current database, you [u]must</u> change the name of the table in the destination field (I will usually just append a number to the name).

Click Next. Make sure that Run Immediately is checked. Click Next. On the next screen, once you click Finish, the table should copy. It will be an exact copy of the other table with some exceptions. For example, your primary keys will have to be redefined as will your Identitys.

Once you are done, you can select any rows that you don't want and delete them.

Hope this helps.

Josh