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