Index Constants (SQLDMO_INDEX_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
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 |
The index is clustered. SQL Server supports a single clustered index on any table. |
SQLDMOIndex_Default |
0 |
The index is nonclustered. |
SQLDMOIndex_DRIIndex |
6144 |
The index is used to maintain declarative referential constraint. |
SQLDMOIndex_DRIPrimaryKey |
2048 |
The index implements a SQL Server PRIMARY KEY constraint. Only a value is returned. For more information, see Key Object. |
SQLDMOIndex_DRIUniqueKey |
4096 |
The index implements a UNIQUE constraint on a table not constrained by primary key. The index is a candidate key. |
SQLDMOIndex_DropExist |
32768 |
Optimizes index creation when an existing index is rebuilt. |
SQLDMOIndex_Hypothetical |
32 |
Redirects index creation, mapping the Index object manipulation to CREATE STATISTICS and DROP STATISTICS statements. |
SQLDMOIndex_IgnoreDupKey |
1 |
Controls error generation if an INSERT or UPDATE operation could cause a constraint violation if the index implements a PRIMARY KEY or UNIQUE constraint. |
SQLDMOIndex_NoRecompute |
16777216 |
Creates the index without statistics computation. For more information, see NoRecompute Property. |
SQLDMOIndex_PadIndex |
256 |
Pads index nodes using a fill factor. |
SQLDMOIndex_SortedData |
512 |
Obsolete. |
SQLDMOIndex_/SortedDataReorg |
8192 |
Obsolete. |
SQLDMOIndex_Unique |
2 |
The index implements a UNIQUE constraint. |
SQLDMOIndex_Valid |
41747 |
The value is valid for index creation. |