SQL DROP or DELETE Database

From WikiOD

Syntax[edit | edit source]

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

Remarks[edit | edit source]

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[edit | edit source]

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]

Credit:Stack_Overflow_Documentation