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....