Friday, November 30, 2012 7:23 AMI need Backup of database Schemas, but i dont want data. Schamas means Structure of the Tables, Views, Stored Procedures and Triggers what not not everything without data.
Friday, November 30, 2012 8:08 AM
script the database.
Right click on the database... -> [Tasks] -> [Script]
Select the database and mark "script all objects in the selected database
Get more details here:
MCITP Database Administrator 2005
MCITP Database Administrator 2008
MCITP Microsoft SQL Server 2008, Database Development
db Berater GmbH
SQL Server Blog (german only)
Friday, December 21, 2012 12:08 PM
i did the same as you said but the problem is that its going in 400k lines, is there any solution to get scripts?