The Index type exposes the following members.

Properties

  NameDescription
AllowPageLocks
Gets or sets the ALLOWPAGEROCK option.
AllowRowLocks
Gets or sets the ALLOWROWLOCK option.
Clustered
Gets or sets if an index is clustered.
Columns
Gets columns associated with this index.
Database
Gets the Database owner.
(Inherited from DatabaseObject.)
DependOn
Gets a collection of the element dependencies.
(Inherited from Element.)
ExtendedProperties
Implements ExtendedProperties()()().
(Inherited from IndexBase.)
FillFactor
Gets or sets the fill factor option.
FullName
Gets the element full name.
(Inherited from Element.)
IgnoreDupKey
Gets or sets the IGNOREDUPKEY option.
IncludedColumns
Gets columns included with this index.
IsSystem
Gets or sets true value if the object is of system type.
(Inherited from Element.)
MaxDop
Gets or sets the MAXDOP option.
Name
Gets or sets an element name.
(Inherited from Element.)
Online
Gets or sets the ONLINE option.
PadIndex
Gets or sets the Pad Index option.
Schema
Implements Schema.
(Inherited from IndexBase.)
SortInTempDb
Gets or sets the SORTINTEMPDB option.
StatisticNoRecompute
Gets or sets the STATISTICNORECOMPUTE option.
Table
Gets or sets TableBase.
(Inherited from IndexBase.)
Unique
Gets or sets if an index is unique.

See Also