Procedure will check if trigger exists in the database and will attempt to drop the trigger.
Arguments
-
v_Object_Name – Name of the trigger, SYSNAME
Note:
Supported in SQL Server versions at this time.
Netezza does not support Triggers as concept at this point;
In the Oracle version of the framework, as work around, please use ‘WHENEVER SQLERROR CONTINUE’ command where needed;
Examples
SQL Server
EXEC DBTD_DROP_TRIGGER_IF_EXISTS 'DBTD_TMP_TRIGGERTABLE_TRIGGER_A';
EXEC DBTD_DROP_TRIGGER_IF_EXISTS 'MyServer.MyDatabase.MySchema.DBTD_TMP_TRIGGERTABLE_TRIGGER_A';
See Also