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

Arguments

  • v_ViewName – Name of the view. 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_VIEW_EXISTS ‘MyView’, ‘Cannot find object’;

Oracle 

      DBTD_ASSERT_VIEW_EXISTS (‘MyView’, ‘Cannot find object’);

Netezza

      CALL DBTD_ASSERT_VIEW_EXISTS (‘MyVIEW’, ‘’);


See Also