Question

Which SQL command is used to remove a column from a table in MySQL?

Options

• UPDATE

• ALTER

• DROP

• DELETE

Answer 1

ALTER

Explanation:

In MySQL, the ALTER TABLE command is used to modify the structure of a table.

To remove a column, we use:

ALTER TABLE table_name DROP COLUMN column_name;

So, the ALTER command is used for removing a column.