SQL CREATE/SHOW/USE/DROP Database Statement

SQL CREATE DATABASE statement to create new database. Oracle SQL you have to first create new database. Before you learn how to create new database you must have to know about SQL structure.

SQL structure is hierarchically, You first create database. Select database for USE. Now you are in selected database are. you are access all table as well as make new table and so many things you can done.

Syntax

You have to create new database use following SQL CREATE DATABASE syntax,

CREATE DATABASE database_name;

Example

SQL> CREATE DATABASE user_db;

SQL SHOW DATABASE Statement

SQL SHOW DATABASE statement to display list of all created database.

SQL> SHOW DATABASES;

+---------------------+
| Database            |
+---------------------+
| information_schema  |
| scott               |
| user_db         |
| demodb              |
+---------------------+ 
4 rows in set (0.01 sec)

SQL USE Statement

IN your SQL number of database exist. So whenever you work with database you must have to select (USE) on database at a time. and you can switch over any time using USE statement.

SQL USE statement to switch your existing selected database with another define database.

Syntax

USE database_name;

Example

SQL> USE user_db;

Database changed

SQL DROP DATABASE Statement

SQL DROP DATABASE statement to drop the existing database any time.

Syntax

DROP DATABASE database_name;

Example

SQL> DROP DATABASE user_db;

Now you can again execute SHOW DATABASE statement. user_db database deleted.

SQL> SHOW DATABASES;

+---------------------+
| Database            |
+---------------------+
| information_schema  |
| scott               |
| demodb              |
+---------------------+ 
3 rows in set (0.00 sec)