Checks that view do not exist in the database. Fails when given view is 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_NOT_EXISTS ‘MyView’, ‘View should be removed’;
Oracle
DBTD_ASSERT_VIEW_NOT_EXISTS (‘MyView’, ‘View should be removed’);
Netezza
CALL DBTD_ASSERT_VIEW_NOT_EXISTS (‘MyVIEW’, ‘View should be removed’);
See Also