Skip to content

Instantly share code, notes, and snippets.

@ducfilan

ducfilan/rename_db_sql_server.sql

Created December 28, 2018 02:33
Show Gist options
  • Save ducfilan/a2f93b3cdfdcad9a49f07d24812d1bf2 to your computer and use it in GitHub Desktop.
Save ducfilan/a2f93b3cdfdcad9a49f07d24812d1bf2 to your computer and use it in GitHub Desktop.
Download ZIP
Rename SQL Server Database
Raw
rename_db_sql_server.sql
ALTER DATABASE [DB_NAME]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
sp_rename 'DB_NAME', 'DB_NAME_NEW' ,'DATABASE';
GO
ALTER DATABASE [DB_NAME_NEW]
SET MULTI_USER
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment