Create Alter Drop Backup and Restore MS SQL Database

PART 2 - Create Alter Drop Backup and Restore Database using MS SQL server Management Studio and Transact SQL

To create Database
CREATE DATABASE [DATABASE_NAME]

To Modify Database Name
ALTER DATABASE [DATABASE_NAME] SET SINGLE_USER WITH ROLLBACK immediate;
GO
ALTER DATABASE [DATABASE_NAME] MODIFY NAME=[DATABASE_NAME_NEW];
GO
ALTER DATABASE [DATABASE_NAME_NEW] SET Multi_USER WITH ROLLBACK immediate;
GO

To Backup Database

To Drop Database
DROP DATABASE [DATABASE_NAME_NEW]

To Restore Database