Assert verifies that specified index is not a unique index. Fail when index has not been found for a specified table or when it does enforce unique values.

Note:
- Netezza does not support indexes at this time, however appliance does have _v_table_index system view that uses IndIsUnique column and might allow users in the future to use this functionality (at list for system objects)

Arguments

  • v_IndexName – index name, Variable Character(255) in Oracle and Netezza, SYSNAME in SQL Server
  • v_ObjectName – table or view name, Variable Character(255) in Oracle and Netezza, SYSNAME in SQL Server
  • v_UserMessage – message to report when assertion fails, Variable Character(255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server

 

Examples

Netezza

CALL DBTD_ASSERT_INDEX_NOT_UNIQUE ('ix_Product_SKU', 'Product', 'should not be unique index');

Oracle

DBTD_ASSERT_INDEX_NOT_UNIQUE ('ix_Product_SKU', 'Product', 'should not be unique index');

SQL Server

EXEC DBTD_ASSERT_INDEX_NOT_UNIQUE 'ix_Product_SKU', 'Product', 'should not be unique index';

 

See Also