DB Test Driven

Assert verifies that database object exists. Fail when object with a given name has not been found in the 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_EXISTS 'MyDatabase.MySchema.sp_MyStoredProcedure', 'cannot find database object';

 
See Also

• DBTD_ASSERT_OBJECT_NOT_EXISTS
• DDL Assertions