Tutorials

Drop Table

Used to remove an entire table from the database. Syntax:

drop table tablename

Example
drop table users;

  • Dropping a table results in losing data.

    An error condition may occur for a DROP TABLE statement if there are existing constraints such as foreign keys that are dependent on the table.

  • SQL
    Database Indexes
    Create Table
    SQL Select
    SQL Alias
    SQL Insert
    SQL Update
    SQL Delete
    SQL Alter
    SQL group by & having
    SQL Subqueries
    SQL Exists, All & Any
    SQL Joins
    SQL Aggregate Functions
    SQL Drop
    SQL Union & All
    Constraints
    Create Views
    SQL Transactions