Hello everyone,
I am creating a simple table like this:
create table x(a number, b varchar2(20));
alter table x modify a constraint a_pk primary key;
insert into x values(1, 'first row');
insert into x values(2, 'second row');
commit;
Then:
SQL> select * from x;
A B
---------- --------------------
1 first row
2 second row
Then I run these commands:
SQL> alter table x drop column a;
Table altered.
SQL> select * from x;
B
--------------------
first row
second row
Question: why am I able to drop this column when it is a PRIMARY KEY for the table? I am not using the CASCADE CONSTRAINT keywords with the DROP COLUMN clause...