Drop (SQL)
From Wikipedia, the free encyclopedia
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 commands to occur inside of a transaction and thus be rolled back.
The typical usage is simply DROP objecttype objectname. For example, the command to drop a table named employees would be:
DROP TABLE employees;
The DROP statement is distinct from the DELETE statement. For example, a DELETE statement might delete some (or all) data from a table, whereas a DROP statement might remove the entire table from the database.
