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.
Please Share