[Emerald] Can you disable foreign key constraints? (then enable after you're done updating)

Andrew Stinson ( (no email) )
Wed, 22 Sep 1999 15:24:51 -0500

We're trying to correct a spelling mistake in the accounttypes table, but
can't update the table because of the Foreign Key constraints with
SubAccounts.Accounttype. How can I disable this long enough to update the
AccountTypes name, or can it be done? I went into the DB, AccountTypes
table, Design Table, Properties for the AccountType column, and removed the
check from Enable relationship for INSERT and UPDATE thinking that might
work (i did it for both tables)....Didn't work...if it's possible (or not)
let me know please.......thanks....
Andrew Stinson
Apex 2000 Internet Services Corporation Phone: (915) 570-1676

For more information about this list (including removal) go to: