On Thu, 31 Jan 2002, Gregory Wood wrote:
> I'd like to drop a foreign key constraint on a table. I know there are a
> number of triggers created by a FK, but how many, how do I find them to
> delete them, and what other gotchas might I find when removing the
> constaint(s)?
>
> It looks like there is an INSERT/UPDATE trigger on the main table, and two
> more on the table it's keyed into (one UPDATE, one DELETE)? If this is true,
> can I just delete those three triggers and be done with it?
You should probably use DROP TRIGGER on them, and you'll need to double
quote the trigger name.