A DROP statement in SQL removes an object from a relational database management system (RDBMS). The types of objects that can be dropped depends on which RDBMS is being used, but most support the dropping of tables, users, and databases. Some systems (such as PostgreSQL) allow DROP and other DDL comands to occur inside of a transaction and thus be rolled back. Wikibooks has more about this subject: SQL Headline text Hello BTEC Group! History A seminal paper, A Relational Model of Data for Large Shared Data Banks, by Dr. Edgar F. Codd, was published in June, 1970 in the Association for Computing Machinery (ACM) journal, Communications of the ACM. Codds... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd. ... A table is the basic component of a relational database management system (RDBMS). ... A database is a collection of information stored in a computer in a systematic way, such that a computer program can consult it to answer questions. ... PostgreSQL is a free software object-relational database server (database management system), released under the flexible BSD-style license. ... A database transaction is a unit of interaction with a database management system or similar system that is treated in a coherent and reliable way independent of other transactions. ... In database technologies, a rollback is an operation which returns the database to some previous state. ...

The typical usage is simply DROP objecttype objectname. For example, the command to drop a table named employees would be:

 DROP TABLE employees;