Assert verifies that database does not exists on the server. Fail when database with a given name has been found on the server.

Note: Supported in Netezza and SQL Server framework versions.

Arguments

  • v_DatabaseName – database name, Variable Character(255) in Netezza, SYSNAME in SQL Server
  • v_UserMessage – message to report when assertion fails, Variable Character(255) in Netezza, NVARCHAR(MAX) in SQL Server

Examples

Netezza

CALL DBTD_ASSERT_DB_NOT_EXISTS ('records_archive', 'archive database should not exist on this server');

SQL Server

EXEC DBTD_ASSERT_DB_NOT_EXISTS 'records_archive', 'archive database should not exist on this server';


See Also