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