statement to delete column in sql

In SQL, the syntax for using the ALTER TABLE statement to delete a table column is: ALTER TABLE table_name DROP COLUMN column_name. This statement permanently deletes all data in the specified column. If the column is part of a foreign key, unique constraint, or primary key, the associated constraints must also be deleted.

SQL statement to delete a column

In SQL, you can useALTER TABLEstatement to delete a column from the table. The syntax is as follows:

ALTER TABLE table_name DROP COLUMN column_name;

Among them:

• table_nameis the name of the table where the column is to be deleted.
• column_nameis the name of the column to be deleted.

Example

Suppose we have a table namedcustomerswhich contains the following columns:

id | name | email | phone

To delete thephonecolumn, you can use the following statement:

ALTER TABLE customers DROP COLUMN phone;

Note:

• After deleting a column, all data in the column All will be permanently deleted.
• If the column being deleted is a foreign key, the foreign key constraint associated with the column must also be deleted.
• If the column being dropped is part of a unique constraint or primary key, these constraints must also be dropped.

The above is the detailed content of statement to delete column in sql. For more information, please follow other related articles on the PHP Chinese website!