DB Test Driven

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

• DBTD_ASSERT_INDEX_CLUSTERED
• DDL Assertions
• Clustered and Nonclustered Indexes Described (External Link)