PROBLEM:

While dropping a column, got the below error.

SOLUTION:

If the column is part of a multi-column constraint, then we have to drop all the columns of that constraint. Dropping a single column will throw an error.

1. Check whether the column is part of Multi-column constraint or not.

We can that the constraint EMP_PK has two columns.

2. So the only option is to drop both the columns.