Flash cards
Review the key moves
What is the main idea behind SQL DROP DATABASE Statement?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
Which statement best captures the main point of this lesson?
Complete the missing token from the example code.
___ DATABASEPut the learning moves in the order that makes the concept easiest to apply.
The SQL DROP DATABASE Statement
The DROP DATABASE statement is used to permanently delete an existing SQL database.
Note
Be careful before dropping a database! Dropping a database deletes the database and all its content (tables, views, stored procedures, and data)!
Syntax
DROP DATABASE
databasename
;Tip
You need administrative privileges to drop a database.
DROP DATABASE Example
The following SQL statement drops an existing database named "testDB":
Example
DROP DATABASE testDB;Tip
Once a database is dropped, you can check that it is removed from the list of databases with: SHOW DATABASES; (MySQL) or SELECT name FROM sys.databases; (SQL Server).