Monday, August 15, 2011

Drop a database

1. You have to be in the master database.
2. Take the database to the single user mode.
3. Drop the database.

use master;GO
alter
database [databaseName]
set single_user with rollback immediate;
drop database [databaseName];

No comments:

Post a Comment