How to take back up of Database Schemas without Data

Question

I 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.

Answer 1

Hallo Vishnuvardhan,

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:
http://msdn.microsoft.com/en-us/library/ms178078(v=sql.105).aspx

---

Uwe Ricken

MCITP Database Administrator 2005
MCITP Database Administrator 2008
MCITP Microsoft SQL Server 2008, Database Development

db Berater GmbH
http://www-db-berater.de
SQL Server Blog (german only)

Answer 2

i did the same as you said but the problem is that its going in 400k lines, is there any solution to get scripts?

---

Regards, Vishnuvardhan