SQL Server ->> 重命名数据库

ALTER DATABASE [oldDB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER DATABASE [oldDB] MODIFY NAME = newDB
GO

ALTER DATABASE newDB SET MULTI_USER
GO

 

posted @ 2015-09-30 17:46  Jerry_Chen  阅读(226)  评论(0)    收藏  举报