create table b(
field1 varchar2(50),
field2 varchar2(50)
field1 varchar2(50),
field2 varchar2(50)
)
ALTER TABLE b ADD CONSTRAINT pk_b PRIMARY KEY (field1,field2) ;
alter table b drop column field2 cascade constraints