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 of the information in it is lost, so use it with caution.
Syntax:
DROP TABLE tableName;
Example:
DROP TABLE EMPLOYEE;Output:
| Table dropped. |
One reply on “Drop Table in SQL”
SQL Tutorial | Learn SQL 2022 - Scaz October 22, 2022 at 5:38 pm
[…] SQL DROP Table […]