SQL-DMO
Index Constants (SQLDMO_INDEX_TYPE)
Index constants describe attributes of a Microsoft® SQL Server™ index. Use index constants when defining an index or interpreting the attributes of an existing index.
| Constant | Value | Description |
|---|---|---|
| SQLDMOIndex_Clustered | 16 | Index is clustered. SQL Server supports a single clustered index on any table. |
| SQLDMOIndex_Default | 0 | Nonclustered index. |
| SQLDMOIndex_DRIIndex | 6144 | Index is used to maintain declarative referential constraint. |
| SQLDMOIndex_DRIPrimaryKey | 2048 | Index implements a SQL Server PRIMARY KEY constraint. Value is returned only. For more information, see Key Object. |
| SQLDMOIndex_DRIUniqueKey | 4096 | Index implements a UNIQUE constraint on a table not constrained by primary key. Index is a candidate key. |
| SQLDMOIndex_DropExist | 32768 | Optimizes index creation when an existing index is rebuilt. |
| SQLDMOIndex_Hypothetical | 32 | Redirects index creation, mapping Index object manipulation to CREATE STATISTICS and DROP STATISTICS statements. |
| SQLDMOIndex_IgnoreDupKey | 1 | Controls error generation when an INSERT or UPDATE operation could cause a constraint violation when the index implements a PRIMARY KEY or UNIQUE constraint. |
| SQLDMOIndex_NoRecompute | 16777216 | Index created with statistics computation off. For more information, see NoRecompute Property. |
| SQLDMOIndex_PadIndex | 256 | Pad index nodes using fill factor. |
| SQLDMOIndex_SortedData | 512 | Obsolete. |
| SQLDMOIndex_SortedDataReorg | 8192 | Obsolete. |
| SQLDMOIndex_Unique | 2 | Index implements a UNIQUE constraint. |
| SQLDMOIndex_Valid | 41747 | Or of values used for index creation. |