Drops an existing table.

Syntax

---

DROP TABLE <Name>

Usage

---

Use this statement to drop a table from a database.

NOTE

---

You cannot drop a table that is involved in any referential integrity links to other tables via foreign keys. You must first alter the table and drop the foreign key constraints before you will be allowed to drop the table.


Examples

---

-- The following statement drops the Customer table.

DROP TABLE "Customer"

Required Privileges

---

The current user must be granted the DROP privilege on the current database in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: