Procedure will check if table exists in the database and will attempt to drop the table.

Arguments

  • v_Object_Name – Table 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_TABLE_IF_EXISTS 'MY_TABLE';

      EXEC DBTD_DROP_TABLE_IF_EXISTS 'MyServer.MyDatabase.MySchema.MY_TABLE';

Netezza

      CALL DBTD_DROP_TABLE_IF_EXISTS('TABLE_1');

See Also