Hi all,

Someone reported the following:

With a trigger "IN_KWESTIE" that has a reference to column
"VELD_A", the following fails (with non-auto-commit):

> DROP TRIGGER IN_KWESTIE;
>
>
> ALTER TABLE TEST ALTER "VELD_A" TO "VELD_B";
>
> Error message
>
> unsuccessful metadata update
> Column VELD_A from table TEST is referenced in IN_KWESTIE

I did some testing as well, and this works fine:

ALTER TABLE TEST DROP VELD_A



Any idea why?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com