?? Way to backup schema only ??

[chenthorn]

Is there a way to only back up the data objects (schema) in a database, not the data itself? via BACKUP DATABASE? I have been generating the sql code for my views, tables, etc, but was wondering if there was an easier way to save all that info into source safe.
Thanks!!

 

[fluteplr]

Got to enterprise manager and script the entire database.

 

[tlbroadbent]

You can also use SQLDMO. See faq183-1637 - How can I script my SQL Server databases from Visual Basic? 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.