Partilhar via


Type Property (Index)

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

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

Sintaxe

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.

Applies To: