Subject | changing foreign keys |
---|---|
Author | leon@diractivity.nl |
Post date | 2001-05-08T16:45:45Z |
Hi,
I have to change a foreign key. I tried:
ALTER TABLE CUSTOMERS DROP CONSTRAINT INTEG_11;
CREATE FOREIGN KEY ...... and so on,
But I get the message: INDEX INTEG_11 is in use. I'm the only user
(SYSDBA) of the database.
How can I alter an existing foreign key ?
Leon
I have to change a foreign key. I tried:
ALTER TABLE CUSTOMERS DROP CONSTRAINT INTEG_11;
CREATE FOREIGN KEY ...... and so on,
But I get the message: INDEX INTEG_11 is in use. I'm the only user
(SYSDBA) of the database.
How can I alter an existing foreign key ?
Leon