CREATE DATABASE
The CREATE DATABASE statement is used to create a new SQL database. The following SQL statement creates a database called "MyDB"
DROP DATABASE
The DROP DATABSE statement is used to drop an existing SQL database.
**Note: Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database.
RENAME DATABASE
We can rename a database in MS SQL Server by using ALTER DATABASE statement or perform a SQL stored procedure.
SHOW/SELECT DATABASE
We can use SQL statement to display a list of database on the SQL Server.