create table items_avail ( pro_id varchar2(10) primary key, mod_id varchar2(5), comp_name varchar2(25) );
I wish to remove the primary key constraint......and add make the prod_id and mod_id as primary keys together. i.e. primary key(prod_id, mod_id)
But he thing is this table is already connected to three more tables by foreign keys.......Please tell me if there is a way !!!!!!
Thanks in advance.
Plz reply ASAP....