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:
SQL> CREATE DATABASE testDB;
|
Make sure you has admin previledge before creating any database. Once
a database is created, you can check it in the list of databases as
follows:
SQL> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| AMROOD |
| TUTORIALSPOINT |
| mysql |
| orig |
| test |
| testDB |
+--------------------+
7 rows in set (0.00 sec)
Thanks for sharing Informative post with us, keep update blog to get more Information to me.
ReplyDeleteartist platform in india || artist portfolio services in mumbai