Thursday, 18 September 2014

SQL CREATE Database

The SQL CREATE DATABASE statement is used to create new SQL database.
Syntax :-
Basic syntax of CREATE DATABASE statement is as follows :-

CREATE DATABASE DatabaseName;

Always database name should be unique within the RDBMS.
Example :-
If you want to create new database <testDB>, then CREATE DATABASE statement would be as follows :

CREATE DATABASE testDB;

Make sure you have admin privilege before creating any database. Once a database is created, you can check it in the list of databases as follows :-



No comments:

Post a Comment