Use the DROP TABLE command to delete a MySQL table. Syntax: DROP TABLE table_name;. Example: Drop a table named employees: DROP TABLE employees;. Note: Deleting a table will permanently delete all data, please make sure to back it up.
MySQL delete table command
How to delete a MySQL table?
Use the DROP TABLE
command to delete a MySQL table.
Syntax:
DROP TABLE table_name;
Parameters:
table_name
: The table to be deleted The name. Example:
To delete the table named employees
, use the following command:
DROP TABLE employees;
Note:
The above is the detailed content of Command to delete table in mysql. For more information, please follow other related articles on the PHP Chinese website!