删除数据库

drop database dbName,

 

但有时候会碰到error,提示DB in use(cannot drop database XXX because it is currently in use)

 

solution:

use master

go

alter database dbName set single_user with rollback immediate ///将数据库回滚到原始配置状态

 

go

drop database dbName

删除数据库,布布扣,bubuko.com

删除数据库

上一篇:Sql order by 和 group BY一起使用时需要注意


下一篇:Shift Scheduling Tutorial (ASP.NET, SQL Server, C#, VB.NET)