TechNet
Export (0) Print
Expand All

IRelationalIndex Interface

 

Represents a SQL Server relational index.

Namespace:   Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)

public interface IRelationalIndex : IIndex, IMetadataObject

NameDescription
System_CAPS_pubpropertyCompactLargeObjects

Gets a value that indicates whether to compact the large object (LOB) data in the index.

System_CAPS_pubpropertyDisallowPageLocks

Gets a value that indicates whether the index allows page locks.(Inherited from IIndex.)

System_CAPS_pubpropertyDisallowRowLocks

Gets a value that indicates whether the index allows row locks.(Inherited from IIndex.)

System_CAPS_pubpropertyFileGroup

Gets the filegroup in which the index pages are stored.

System_CAPS_pubpropertyFileStreamFileGroup

Gets the filegroup of the index file stream.

System_CAPS_pubpropertyFileStreamPartitionScheme

Gets the partition scheme name for the index.

System_CAPS_pubpropertyFillFactor

Gets the percentage of an index page to fill when the index is created or re-created.(Inherited from IIndex.)

System_CAPS_pubpropertyFilterDefinition

Gets the index filter definition text.

System_CAPS_pubpropertyIgnoreDuplicateKeys

Gets a value that indicates whether the index ignores duplicate keys.(Inherited from IIndex.)

System_CAPS_pubpropertyIndexedColumns

Gets the collection of columns that are participating in the index.

System_CAPS_pubpropertyIndexKey

Gets the index key that is associated with the index.

System_CAPS_pubpropertyIsClustered

Gets a value that indicates whether the index is clustered.

System_CAPS_pubpropertyIsDisabled

Gets a value that indicates whether the index is disabled.(Inherited from IIndex.)

System_CAPS_pubpropertyIsSystemNamed

Gets a value that indicates whether the index was named automatically by the system.

System_CAPS_pubpropertyIsUnique

Gets a value that indicates whether the index is unique.

System_CAPS_pubpropertyName

Gets the name of the metadata object.(Inherited from IMetadataObject.)

System_CAPS_pubpropertyNoAutomaticRecomputation

Gets a value that indicates whether statistics are regenerated when the index is created.

System_CAPS_pubpropertyPadIndex

Gets a value that indicates whether the space is left open on each page of the intermediate levels of the index.(Inherited from IIndex.)

System_CAPS_pubpropertyParent

Gets the ITabular object that is the parent of this object.(Inherited from IIndex.)

System_CAPS_pubpropertyPartitionScheme

Gets the partition scheme that is associated with the index.

System_CAPS_pubpropertyType

Gets the type of the index.(Inherited from IIndex.)

NameDescription
System_CAPS_pubmethodAccept<T>(IMetadataObjectVisitor<T>)

Accepts a visit from the specified IMetadataObjectVisitor<T> object.(Inherited from IMetadataObject.)

Return to top
Show:
© 2016 Microsoft