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