Checks that table exists in the database. Report failure if table not 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_EXISTS ‘MyTable’, ‘Cannot find my table in the database’;

Oracle 

      DBTD_ASSERT_TABLE_EXISTS (‘MyTable’, ‘Cannot find my table in the database’);

Netezza

      CALL DBTD_ASSERT_TABLE_EXISTS (‘MyTable’, ‘Cannot find my table in the database’);
 

See Also