SQLDROP 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]