backup SQL Server 2005 database without data

Question

I have one stored procedure to backup the database. It will backup metadata as well as data.

Is there any option to back up the database with out data. ie, back up only the schema (Empty tables).

I don't want to script the database.

Answer 1

You can do using SQL SERVER SCRIPT WIZARD

Answer 2

There's a solution already on StackOverflow - here.