Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :

Previous PageTable Of ContentsNext Page

3.3.38 DROP TABLE

Name

DROP TABLE -- remove a table

Synopsis

DROP TABLE name

Description

DROP TABLE removes tables from the database. Only its owner may destroy a table. To empty a table of rows, without destroying the table, use DELETE.

DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table.

Parameters

name

The name (optionally schema-qualified) of the table to drop.

Examples

To destroy table, emp:

DROP TABLE emp;

See Also

ALTER TABLE, CREATE TABLE

Previous PageTable Of ContentsNext Page