Foreign Keys

From: Chumley <mschumle_at_willscot.com>
Date: Fri, 14 May 1999 11:05:23 -0400
Message-ID: <7hhe3f$ftq$1@paxfeed.eni.net>

Has anyone had an experience where foreign keys on tables "magically" are removed. I have been running some archiving/purge procedures from my development team. Since then I have noticed that several foreign keys have been removed, which in turn cause data integrity errors. I have verified that the procedures do not use any ALTER statements to drop the foreign keys.

Can cursors and deletes cause the foreign keys to be removed? Received on Fri May 14 1999 - 10:05:23 CDT