Drop option in the ALTER TABLE command is used to delete the Constraints on the table or delete column in the table.
Example:-
Alter table <table-name> drop constraint <constraint name>

Alter table <table-name> drop column <column name>