The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ component.
object.Type [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer specifying index attributes as described in Settings |
| 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 and 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. |
Long, enumerated
Read/write when using the Index object to define a SQL Server index. Read-only when the Index object references an existing SQL Server index.
HRESULT GetType(SQLDMO_INDEX_TYPE* pRetVal)
HRESULT SetType(SQLDMO_INDEX_TYPE NewValue)