What is the use of the DROP option in the ALTER TABLE command?

It is used to drop constraints specified on the table.

Interview Candidate
Jul 18th, 2005
3
6105

Showing Answers 1 - 3 of 3 Answers

Naveen Mishra

Jul 18th, 2005

DROP option can be used to drop a col from table as well.
Alter table tname drop column colName;

Anuradha

Oct 13th, 2005

Ans:
The given answer says the use of DROP command.but not the drop option in the ALTER TABLE command.
Drop option in the ALTER TABLE command is uesd to drop columns you no longer need from the table.
The column may or may not contain data
using alter column statement only one column can be dropped at a time.
The table must have at least one column remaining in it after it is altered.
once a column is dropped,it cannot be recovered.