SQL Database

CREATE:
The CREATE DATABASE statement is used to create a database.

Syntax: CREATE DATABASE database_name;  

SELECT:
It is used to select a database first before executing any query on table.

Syntax: DATABASE database_name;  

RENAME:
RENAME DATABASE is used when you need to change the name of your database.

Syntax: RENAME DATABASE old_db_name TO new_db_name;  

DROP:
DROP statement is used to delete or remove indexes from a table in the database.

Syntax: DROP DATABASE database_name;  

Posted on by