The DROP TABLE statement is used to delete an existing table definition, indexes, constraints, access privileges and all associated data.
Note: When a table is deleted all the available information in the table will be lost, so use it carefully.
Syntax:
DROP TABLE tableName;
Example:
DROP TABLE EMPLOYEE; |
Output:
Table dropped. |
Next Topic: SQL DELETE from table with example.
Previous Topic: SQL RENAME Table with example.