DROP column in table
Syntax:
ALTER TABLE table_name
DROP COLUMN column_name;
Let’s take an example to drop the column name “cus_address” from the table “cus_tbl”.
Use the following query to do this:
ALTER TABLE cus_tbl
DROP COLUMN cus_address;
Output:
See the table structure: