GNU Info

(mysql.info)DROP DATABASE

---

Next: CREATE TABLE Prev: CREATE DATABASE Up: Data Definition

---

Enter node , (file) or (file)node

`DROP DATABASE' Syntax
----------------------

     DROP DATABASE [IF EXISTS] db_name

`DROP DATABASE' drops all tables in the database and deletes the
database.  If you do a `DROP DATABASE' on a symbolic linked database,
both the link and the original database is deleted. *Be VERY careful
with this command!*

`DROP DATABASE' returns the number of files that were removed from the
database directory.  Normally, this is three times the number of
tables, because normally each table corresponds to a `.MYD' file, a
`.MYI' file, and a `.frm' file.

The `DROP DATABASE' command removes from the given database directory
all files with the following extensions:

.BAK               .DAT               .HSH               .ISD
.ISM               .ISM               .MRG               .MYD
.MYI               .db                .frm               

All subdirectories that consists of 2 digits (`RAID' directories) are
also removed.

In MySQL Version 3.22 or later, you can use the keywords `IF EXISTS' to
prevent an error from occurring if the database doesn't exist.

You can also drop databases with `mysqladmin'. Note: Client-Side
Scripts.

CREATE TABLE

`CREATE TABLE' Syntax

ALTER TABLE

`ALTER TABLE' Syntax

RENAME TABLE

`RENAME TABLE' Syntax

DROP TABLE

`DROP TABLE' Syntax

CREATE INDEX

`CREATE INDEX' Syntax

DROP INDEX

`DROP INDEX' Syntax