Home » MCQs » MySQL MCQs

Suppose you are asked to drop a column using alter statement then which syntax you will follow?

20. Suppose you are asked to drop a column using alter statement then which syntax you will follow?

1. ALTER table_name TABLE DROP COLUMN column_name;
2. ALTER TABLE table_name DROP COLUMN column_name;

Answer: B) ALTER TABLE table_name DROP COLUMN column_name;

Explanation:

we will use the following syntax,

ALTER TABLE table_name DROP COLUMN column_name;