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 :-
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