Command to delete table in mysql

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:

<code class="sql">DROP TABLE table_name;</code>

Parameters:

• table_name: The table to be deleted The name.

Example:

To delete the table named employees, use the following command:

<code class="sql">DROP TABLE employees;</code>

Note:

• Deleting a table will permanently delete all data in the table.
• Make sure you have backed up the data before deleting the table.
• If the table has foreign key constraints, these constraints must be dropped before dropping the table.
• You can only delete tables that you have permission to delete.

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!