Question

Choose the correct command to delete an attribute A from a relation R

(a) alter table R delete A

(b) alter table R drop A

(c) alter table drop A from R

(d) delete A from R

The question was posed to me by my school principal while I was bunking the class.

The question is from SQL Data definition topic in section Introduction to Relational Model and Sql of RDBMS

Answer 1

Correct option is (b) alter table R drop A

The best I can explain: We can delete an attribute from a relation using the alter table command with the following syntax

alter table  drop