Assert verifies that index specified as clustered index for a given table. Fail when index has not been found or when it is not a clustered index.

Note:
- Supported in SQL Server framework version only.

Arguments

  • v_IndexName – index name, SYSNAME
  • v_ObjectName – table or view name, SYSNAME
  • v_UserMessage – message to report when assertion fails, NVARCHAR(MAX) 

 

Examples

SQL Server  

EXEC DBTD_ASSERT_INDEX_CLUSTERED 'ix_CLUSTERED_Product_Name', 'Product', 'index is not clustered';

 

See Also