Assert verifies that database object does not exists. Fail when object with a given name has been found in a database.

Arguments

  • v_ObjectName – database object name, SYSNAME
  • v_UserMessage – message to report when assertion fails, NVARCHAR(MAX)

 

Examples

SQL Server 

EXEC DBTD_ASSERT_OBJECT_NOT_EXISTS 'MyDatabase.MySchema.sp_MyStoredProcedure', 'this object should be deleted already';

 
See Also