Drop Table

Structured Query Language · Wikibooks

0%

Contents

    Text

    Size
    100%
    Theme
    Typeface
    Line length
    Spacing

    From Wikibooks, under CC BY-SA 4.0, as the source states it. This page at Wikibooks.

    Illustration Alter Table Structured Query Language
    Drop Table     		Temporary Table Illustration



    The DROP TABLE command removes the definition and all data of the named table from the database. 

    DROP TABLE <t1>;

    The command handles the table as a whole. It will not fire any trigger. But it considers Foreign Key definitions. If any other table refers to the table to be dropped, the DROP TABLE command will fail. The Foreign Key definition must be dropped first.

    As the DROP TABLE command handles the table as a whole, it is very fast.


    Illustration Alter Table Structured Query Language
    Drop Table     		Temporary Table Illustration