Delete MySQL Column: SQL ALTER TABLE Guide

1 year ago
Emily Johnson
1 minute

To delete a column from a table, you can use the ALTER TABLE statement and specify the name of the column you want to remove. Here is an example SQL statement:

ALTER TABLE table_name
DROP COLUMN column_name;

Please replace “table_name” with the name of the table from which you want to delete the field, and replace “column_name” with the name of the field you want to delete. After executing the above SQL statement, the specified field will be deleted from the table.

bannerAds