Create Database in Management Studio

Hi

Does anyone know how to create an empty database in Management Studio. Or how to get rid of tables that are in the default database that the default script creates using a single command.

By deault the database is created with all the tables from Model database, and to get rid of tables individually, one has to go and look at all the dependencies before they can be deleted.

Thanks

Alvin

Hi,

once we did that our own. The model database could not be changed for some reason I can′t remember :-) So we wrote a stored procedure which copied a template to a specified folder and attach the database to the server. The template database was clear from the users / objects we did not want to have in the new database.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de