Type Property (Index)
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。
The Type property exposes configured attributes of the referenced Microsoft SQL Server component.
語法
object
.Type [= value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer that specifies index attributes as described in Settings.
Data Type
Long, enumerated
Modifiable
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.
Prototype (C/C++)
HRESULT GetType(SQLDMO_INDEX_TYPE* pRetVal)
HRESULT SetType(SQLDMO_INDEX_TYPE NewValue)
Settings
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 a declarative referential constraint. |
SQLDMOIndex_DRIPrimaryKey |
2048 |
The index implements a SQL Server PRIMARY KEY constraint. A value is returned only. 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 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 |
Creates index with statistics computation off. For more information, see NoRecompute Property. |
SQLDMOIndex_PadIndex |
256 |
Index nodes are padded 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 index is valid. |