var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: drop primary key
I added a primary keys and foreign keys to my tables using:
alter table employee add primary key (ssn);
alter table project add primary key (pnumber);
alter table works_on add foreign key (essn) references employee(ssn);
alter table works_on add foreign key (pno) references project(pnumber);
And now I want to drop all the primary keys and foreign keys. I started first by trying to drop the foreign keys by using:
alter table works_on drop constraint pno; -- which doesn't work
I think im using the wrong syntax and it won't let me drop it. What is the correct syntax to drop the foreign keys and then the primary keys?
Thanks ahead of time.
Last edited by nickbn; 10-30-03 at
I found the problem. I wasn't defining any names for the primary keys and foreign keys so the system assigned them. I then found the names from the constraints_name field of the user_constraints dictionary.