SQL Database:

SQL Create Database:

The Create Database Statement is used to create Database in SQL.

Syntax:

CREATE DATABASE databasename;

Example:

CREATE DATABASE luckyItHub;

Drop Database:

The Drop Database statement is used to drop an existing SQL Database.

Syntax:

DROP Database DatabaseName;

Example:

DROP Database luckyItHub;

SHOW Databases:

The SHOW Databases Statement is used to display list of available Databases.

Syntax:

SHOW Databases;

Select Database:

To select specific Database from List of Databases we should use “use” command.

Syntax:

Use Databasename;

Example:

Use luckyItHub;