Index Class Members

AllowPageLocks	True if the index allows page locks.
AllowRowLocks	True if the index allows row locks.
Clustered	True if the index is clustered.
Database	The database to which the index belongs.
Fields	The fields in the index.
FileGroup	The filegroup or the partition scheme on which the index is defined.
FillFactor	The fill factor.
FullTextKey	True if the index is used in a full-text key.
FullyQualifiedName	The fully-qualified name of the index.
IgnoreDuplicateKeys	True if set to ignore duplicate keys.
IsDisabled	Indicates whether the index is disabled.
IsPartitioned	Indicates whether the index is built on a partition scheme. If it is, the name of the partition scheme is returned by the filegroup property.
Name	The name of the index.
NoRecompute	True if the index is defined with NORECOMPUTE.
ObjectType	Returns ObjectType.Index
Owner	The owner of the index. This is undefined.
Pad	The index padding.
PartitionedField	Indicates the field over which the index is partitioned. This is a SQL Server 2005 feature.
PrimaryKey	True if the index is a primary key.
ScriptSource	The location of the creation script for this object if the database source is set to scripts folder.
Statistics	True if the index is a statistic.
Unique	True if the index is unique.
UniqueConstraint	True if the index is a unique constraint.
Xml	True if the index is an XML index.
XmlIndexType	The type of the XML index. This type can be Value, Path, Property, or None.
XmlPrimaryIndex	The primary XML index, if this index is a secondary XML index.