SQL Basics

SQL Joins

SQL Functions

SQL Database

SQL Tables

SQL Constraints

SQL Data Types

SQL Performance

SQL Advanced

SQL Security

SQL DROP DATABASE

SQL DROP DATABASE

What you'll learn

  • Understand the main ideas in SQL DROP DATABASE.
  • See a working example and explanation to help you learn by doing.
  • Follow a clear path to the next lesson in this topic.

When to use this lesson

Use this lesson when you want to understand the key concepts behind SQL DROP DATABASE.

❮ Previous Next ❯

SQL DROP DATABASE

The DROP DATABASE statement is used to permanently delete an existing SQL database.

Warning: Be extremely careful with this command! Deleting a database will result in the loss of all data stored within it. This action is irreversible. Always make a backup before dropping a database.

Syntax

The syntax is simple:

DROP DATABASE database_name;

Example

The following SQL statement deletes the database named "TestDB":

DROP DATABASE TestDB;
❮ Previous Next ❯