DROP or DELETE Database

Syntax#

• MSSQL Syntax:
• DROP DATABASE [ IF EXISTS ] { database_name | database_snapshot_name } [ ,…n ] [;]
• MySQL Syntax:
• DROP {DATABASE | SCHEMA} [IF EXISTS] db_name

Remarks#

DROP DATABASE is used for dropping a database from SQL. Be sure to create a backup of your database before dropping it to prevent accidental loss of information.

DROP Database

Dropping the database is a simple one-liner statement. Drop database will delete the database, hence always ensure to have a backup of the database if required.

Below is the command to drop Employees Database

DROP DATABASE [dbo].[Employees]