TechNet
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

NameDescription
System_CAPS_pubpropertyCompactLargeObjects

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

System_CAPS_pubpropertyDisallowPageLocks

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

System_CAPS_pubpropertyDisallowRowLocks

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

System_CAPS_pubpropertyFileGroup

Gets or sets the filegroup in which the index pages are stored.

System_CAPS_pubpropertyFileStreamFileGroup

Gets or sets the filegroup of the index file stream.

System_CAPS_pubpropertyFileStreamPartitionScheme

Gets or sets the partition scheme name for the index.

System_CAPS_pubpropertyFillFactor

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

System_CAPS_pubpropertyFilterDefinition

Gets or sets the index filter definition text.

System_CAPS_pubpropertyIgnoreDuplicateKeys

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

System_CAPS_pubpropertyIndexedColumns

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

System_CAPS_pubpropertyIndexKey

Gets or sets the index key that is associated with the index.

System_CAPS_pubpropertyIsClustered

Gets or sets a value that indicates whether the index is clustered.

System_CAPS_pubpropertyIsDisabled

Gets or sets a value that indicates whether the index is disabled.(Inherited from IMutableIndex.)

System_CAPS_pubpropertyIsSystemNamed

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

System_CAPS_pubpropertyIsUnique

Gets or sets 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 or sets a value that indicates whether statistics are regenerated when an index is created.

System_CAPS_pubpropertyPadIndex

Gets 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.)

System_CAPS_pubpropertyParent

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

System_CAPS_pubpropertyPartitionScheme

Gets or sets 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