Quote:
Originally posted by janrune
Oops....
Is there a way to make sure there is no trigger besides "DROP TRIGGER xxxx" ???
Thanks
JR
|
Not sure what you mean. To investigate if there are triggers, you can select from syscat.triggers. I.e.
select * from syscat.triggers where trigname = 'KT_Key_Table_Upd'
But inorder to get rid of a trigger you use drop. I.e.
drop trigger DBO.KT_Key_Table_Upd
BTW, could you post ddl for the table and trigger?
/Lennart