.png)
IRelationalIndex Interface
SQL Server 2012
Represents a SQL Server relational index.
Namespace: Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly: Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)
The IRelationalIndex type exposes the following members.
| Name | Description | |
|---|---|---|
 | CompactLargeObjects | Gets a value that indicates whether to compact the large object (LOB) data in the index. |
| DisallowPageLocks | Gets a value that indicates whether the index allows page locks. (Inherited from IIndex.) |
| DisallowRowLocks | Gets a value that indicates whether the index allows row locks. (Inherited from IIndex.) |
| FileGroup | Gets the filegroup in which the index pages are stored. |
| FileStreamFileGroup | Gets the filegroup of the index file stream. |
| FileStreamPartitionScheme | Gets the partition scheme name for the index. |
| FillFactor | Gets the percentage of an index page to fill when the index is created or re-created. (Inherited from IIndex.) |
| FilterDefinition | Gets the index filter definition text. |
| IgnoreDuplicateKeys | Gets a value that indicates whether the index ignores duplicate keys. (Inherited from IIndex.) |
| IndexedColumns | Gets the collection of columns that are participating in the index. |
| IndexKey | Gets the index key that is associated with the index. |
| IsClustered | Gets a value that indicates whether the index is clustered. |
| IsDisabled | Gets a value that indicates whether the index is disabled. (Inherited from IIndex.) |
| IsSystemNamed | Gets a value that indicates whether the index was named automatically by the system. |
| IsUnique | Gets a value that indicates whether the index is unique. |
| Name | Gets the name of the metadata object. (Inherited from IMetadataObject.) |
| NoAutomaticRecomputation | Gets a value that indicates whether statistics are regenerated when the index is created. |
| PadIndex | Gets a value that indicates whether the space is left open on each page of the intermediate levels of the index. (Inherited from IIndex.) |
| Parent | Gets the ITabular object that is the parent of this object. (Inherited from IIndex.) |
| PartitionScheme | Gets the partition scheme that is associated with the index. |
| Type | Gets the type of the index. (Inherited from IIndex.) |
| Name | Description | |
|---|---|---|
| Accept<T> | Accepts a visit from the specified IMetadataObjectVisitor<T> object. (Inherited from IMetadataObject.) |
