How to copy structure of database in another database in sql server 2008? [closed]

Question

i have a database and want to copy all the tables in new database without copying the dat of all those tables only structure should be copy

Answer 1

SQL Server Management Studio offers the following:

Scripting the whole database:

• Under the Object Explorer, right mouse click on the database and then select Script Database as

To script just (specific) tables:

• In Object Explorer, right mouse click on the database, select Tasks, then Generate Scripts, and then select the tables that you want.

You can then use the script to create a new database / new objects elsewhere. If you change the name of the database, remember to change the USE xxx statement(s) accordingly.