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?
- ALTER table_name TABLE DROP COLUMN column_name;
- 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;