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