Assert verifies that specified index is NOT a clustered index. Fail when index has not been found or when index is 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_NOT_CLUSTERED 'ix_Product_Name', 'Product', 'index should not be clustered';

 

See Also