Export (0) Print
Expand All

IMutableRelationalIndex Interface

Represents a mutable SQL Server relational index.

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

public interface IMutableRelationalIndex : IRelationalIndex, 
	IMutableIndex, IIndex, IMutableMetadataObject, IMetadataObject

The IMutableRelationalIndex type exposes the following members.

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