Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 sql server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-05-20 : 09:13:27
manohar writes "how I can copy a table design in SQL server"

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-05-20 : 09:21:13
right click on the table in EM, go to All Tasks -> Generate SQL Script...
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-05-20 : 09:46:41
Here's a neat trick. Select the tables in EM, right-click and select Copy (or do a Ctrl+C), open notepad and hit Ctrl+V. Voila, instant scripting!

OS
Go to Top of Page
   

- Advertisement -