create tables in sql 1

[kporters]

I need to have multiple tables with the same format in my db. Is there an easy (read quick) method to copy a table format into a new table?

thanks in advance
-k

 

[DrewConn]

Go into the table design and click on the generate scripts icon. This will create a script that will create the same table. Once created, edit the script. Change the name of the table to one you want and you probably will want to delete the drop table lines. I don't know how many times I have forgotton to delete those pesky lines and have deleted a table with data in it. Hope this helps