Copy schema of all tables and procedures from a database in SQL SERVER 2008

[samnine]

I would like to copy script/schema of all the tables and stored procedures of a database and restore it in the database on client machine. But I don't want to copy DATA of database. Because, I have test data in the database on my development machine and don't want to copy this data on client machine.

This can be done manually by right clicking table and selecting "Script Table As >> CREATE TO", but it is a manual process and time consuming.

Is there a way copy all the table and proc schema at once WITHOUT coping actual DATA.

Thanks in Advance.

[nico5038]

Checkout: http://blog.sqlauthority.com/2007/08...abase-objects/

Nic;o)