SQL Server中使用SQL语句关闭数据库连接和删除数据库文件

所以这个方法的核心就是先更改数据库模式为单用户模式"SINGLE_USER"，那么什么是数据库的单用户模式呢？我这里贴出一个从网上找到的解释：

So in single_user mode - you would be quite unlikely to have locking problems in that database. It is what it sounds like - single user - and it doesn‘t mean Single Username - it means one user. So it‘s used when you as a DBA want to do something that can‘t be done with others users in. Maybe you are trying to do a repair option of a checkdb. Maybe you are trying to change some object metadata and don‘t have a better way to kick other users out. Etc.

上面的解释来自：What happens when SQL Server is in Single User Mode?

所以数据库单用户模式"SINGLE_USER"，是指只能有一个用户连接能够连接到数据库，这样我们就可以在没有其它数据库连接的情况下，执行DROP DATABASE语句来删除数据库和其数据库文件了。

SQL Server中使用SQL语句关闭数据库连接和删除数据库文件

标签：语句   tab   关闭数据库   关闭   others   模式   exchange   and   库文件