Disabling Foreign Key

zarierb · #1 (**permalink**) 12-22-04, 03:25

Is it possible to disable a foreign key in DB2 v8 Universal Database.

Wim · #2 (**permalink**) 12-22-04, 04:50

Code:

ALTER TABLE mytable
DROP FOREIGN KEY myforeignkeyname
;

If you don't know the name of the FK, check out the system table or do it the quick and dirty way: try to update the referencing column into a value that does not occur in the parent table.

Wim

Internet Services

Web Development

Digital Marketing

Consumer Tech