MS SQL 2008 – Create a copy of the database without the data
Right click the Database and select Tasks -> Generate Scripts. You can you then select all the objects you require or only certain objects. There are some Script Options that you should look at: Script USE DATABASE – You should set this to false if you are creating a new database with a different name. … Read more