Type Property (Index)

SQL-DMO

SQL-DMO

Type Property (Index)

The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ 2000 component.

Applies To
Index Object
Syntax

object.Type [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

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 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.