You probably need to make sure to double quote the tgname in your drops.
On Thu, 7 Jun 2001, Linh Luong wrote:
> Hi,
>
> Is there to drop a constraint when you add it separately with an alter
> statement.
>
> alter table failuretypecategory1 add constraint fk_failuretypecategory1
> FOREIGN K
Hi,
Is there to drop a constraint when you add it separately with an alter
statement.
alter table failuretypecategory1 add constraint fk_failuretypecategory1
FOREIGN KEY (failurecategory1id)
REFERENCES failurecategory1 (id) ON UPDATE CASCADE ON DELETE CASCADE;
I tried
drop trigger on failu
