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

The IRelationalIndex type exposes the following members.

  NameDescription
Public propertyCompactLargeObjectsGets a value that indicates whether to compact the large object (LOB) data in the index.
Public propertyDisallowPageLocksGets a value that indicates whether the index allows page locks. (Inherited from IIndex.)
Public propertyDisallowRowLocksGets a value that indicates whether the index allows row locks. (Inherited from IIndex.)
Public propertyFileGroupGets the filegroup in which the index pages are stored.
Public propertyFileStreamFileGroupGets the filegroup of the index file stream.
Public propertyFileStreamPartitionSchemeGets the partition scheme name for the index.
Public propertyFillFactorGets the percentage of an index page to fill when the index is created or re-created. (Inherited from IIndex.)
Public propertyFilterDefinitionGets the index filter definition text.
Public propertyIgnoreDuplicateKeysGets a value that indicates whether the index ignores duplicate keys. (Inherited from IIndex.)
Public propertyIndexedColumnsGets the collection of columns that are participating in the index.
Public propertyIndexKeyGets the index key that is associated with the index.
Public propertyIsClusteredGets a value that indicates whether the index is clustered.
Public propertyIsDisabledGets a value that indicates whether the index is disabled. (Inherited from IIndex.)
Public propertyIsSystemNamedGets a value that indicates whether the index was named automatically by the system.
Public propertyIsUniqueGets a value that indicates whether the index is unique.
Public propertyNameGets the name of the metadata object. (Inherited from IMetadataObject.)
Public propertyNoAutomaticRecomputationGets a value that indicates whether statistics are regenerated when the index is created.
Public propertyPadIndexGets a value that indicates whether the space is left open on each page of the intermediate levels of the index. (Inherited from IIndex.)
Public propertyParentGets the ITabular object that is the parent of this object. (Inherited from IIndex.)
Public propertyPartitionSchemeGets the partition scheme that is associated with the index.
Public propertyTypeGets the type of the index. (Inherited from IIndex.)
Top

  NameDescription
Public methodAccept<T>Accepts a visit from the specified IMetadataObjectVisitor<T> object. (Inherited from IMetadataObject.)
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft