Procedure will check if sequence with the given name exists in the database and will attempt to drop it.

Arguments

  • v_Object_Name – Sequence Name, Variable Character (128) in Netezza, SYSNAME in SQL Server.

Note:
Supported in Netezza and SQL Server versions at this time. As workaround In the Oracle version of the framework please use ‘WHENEVER SQLERROR CONTINUE’ command where needed;

Examples

SQL Server

      EXEC DBTD_DROP_SEQUENCE_IF_EXISTS 'SEQUENCE_B';

      EXEC DBTD_DROP_SEQUENCE_IF_EXISTS 'MyServer.MyDatabase.MySchema.SEQUENCE_B';

 
Netezza

      CALL DBTD_DROP_SEQUENCE_IF_EXISTS('SEQUENCE_1');

See Also