T-SQL - CREATE DATABASE
The T-SQL (Transact-SQL) CREATE DATABASE statement is used to create a new SQL Server database.
Syntax
The syntax of using CREATE DATABASE statement in T-SQL (Transact-SQL) is given below:
CREATE DATABASE DatabaseName;
Please note that to create any database, appropriate privilege is required. Along with this, the database name should be unique within the RDBMS. After creating the database, the following statement can be used to see the list of databases available in RDBMS.
SELECT name FROM sys.databases;
Example: create a database
To create a database with name testDB, the following statement can be used:
CREATE DATABASE testDB;
After creating the database, the below mentioned statement can be used to see the list of databases available in RDBMS.
SELECT name FROM sys.databases;
This will produce the result which will be similar to:
name -------------- SQLExample1 SQLExample2 SQLExample3 SQLExample4 SQLExample5 SQLExample6 SQLExample7 SQLExample8 testDB