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 Administration (2000)
 Table Structure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-15 : 07:05:38
Jay writes "Sir,
I Have SQL-SERVER Database.
I Want Backup of Table Structre Only i.e. Blank Database.

Thanks in Advance

Jay"

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2005-02-15 : 07:49:00
Launch Enterprise Manager
Navigate to the database you want a backup of
Select from the menu - Action | All Tasks | Generate Sql Scripts
Select options you want from all 3 tabs and click OK.

That will give you a scrip that you can either save and or run on a new blank database (creating a copy of original)

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -