DROP TABLE

    Description

    removes tables from the database. Only its owner may drop a table. To empty a table of rows without removing the table definition, use DELETE or TRUNCATE.

    always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is referenced by a view, CASCADE must be specified. CASCADE will remove a dependent view entirely.

    IF EXISTS

    Do not throw an error if the table does not exist. A notice is issued in this case.

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

    CASCADE

    Automatically drop objects that depend on the table (such as views).

    RESTRICT

    Examples

    Remove the table :

    1. DROP TABLE mytable;

    DROP TABLE is fully conforming with the SQL standard, except that the standard only allows one table to be dropped per command. Also, the option is a Greenplum Database extension.

    See Also

    CREATE TABLE, , TRUNCATE

    Parent topic: