Name
DROP DATABASE
Syntax
DROP DATABASE [IF EXISTS] name
Description
Permanently remove a database from MySQL. Once you execute this
statement, none of the tables or data that made up the database are
available. All the support files for the database are deleted from
the filesystem. The number of files deleted will be returned to the
user. This statement is equivalent to running the
mysqladmin drop utility. As with running
mysqladmin, you must be the administrative user
for MySQL (usually root or mysql) to perform
this statement.You may use the IF EXISTS
clause to
prevent any error message that would result from an attempt to drop a
nonexistent table.
Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.