Checks that table does not exist in the database. Fails when given table is found.

Arguments

  • v_TableName – Name of the table. Supports four part object name. Variable Character(255) in Oracle and Netezza, SYSNAME in SQL Server
  • v_UserMessage – message to report when assertion fails, Variable Character(255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server


Examples

SQL Server 

       EXEC DBTD_ASSERT_TABLE_NOT_EXISTS ‘MyTable’, ‘Table should be removed’;

Oracle

       DBTD_ASSERT_TABLE_NOT_EXISTS (‘MyTable’, ‘Table should be removed’);

Netezza

      CALL DBTD_ASSERT_TABLE_NOT_EXISTS (‘MyTable’, ‘Table should be removed’);


See Also