An emp table contains fields employ name, desig and salary. How do you drop column salary?
Answer options
A
ALTER TABLE emp DROP COLUMN salary;
B
DROP COLUMN salary FROM emp;
C
ALTER emp DROP salary;
D
DELETE COLUMN salary FROM emp;
Correct answer: ALTER TABLE emp DROP COLUMN salary;
Explanation
The correct DDL syntax is: ALTER TABLE emp DROP COLUMN salary;