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.

- Supported in SQL Server framework version only.


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



SQL Server  

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


See Also