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)

Syntax

'Declaration
Public Interface IMutableRelationalIndex _
    Inherits IRelationalIndex, IMutableIndex, IIndex, IMutableMetadataObject,  _
    IMetadataObject
'Usage
Dim instance As IMutableRelationalIndex

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

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

type IMutableRelationalIndex =  
    interface 
        interface IRelationalIndex 
        interface IMutableIndex 
        interface IIndex 
        interface IMutableMetadataObject 
        interface IMetadataObject 
    end

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

The IMutableRelationalIndex type exposes the following members.

Properties

	Name	Description
	CompactLargeObjects	Gets or sets a value that indicates whether to compact the large object (LOB) data in the index.
	DisallowPageLocks	Gets or sets a value that indicates whether the index allows page locks. (Inherited from IMutableIndex.)
	DisallowRowLocks	Gets or sets a value that indicates whether the index allows row locks. (Inherited from IMutableIndex.)
	FileGroup	Gets or sets the filegroup in which the index pages are stored.
	FileStreamFileGroup	Gets or sets the filegroup of the index file stream.
	FileStreamPartitionScheme	Gets or sets the partition scheme name for the index.
	FillFactor	Gets or sets the percentage of an index page to fill when the index is created or re-created. (Inherited from IMutableIndex.)
	FilterDefinition	Gets or sets the index filter definition text.
	IgnoreDuplicateKeys	Gets or sets a value that indicates whether the index ignores duplicate keys. (Inherited from IMutableIndex.)
	IndexedColumns	Gets the collection of columns that are participating in the index.
	IndexKey	Gets or sets the index key that is associated with the index.
	IsClustered	Gets or sets a value that indicates whether the index is clustered.
	IsDisabled	Gets or sets a value that indicates whether the index is disabled. (Inherited from IMutableIndex.)
	IsSystemNamed	Gets or sets a value that indicates whether the index was named automatically by the system.
	IsUnique	Gets or sets a value that indicates whether the index is unique.
	Name	Gets the name of the metadata object. (Inherited from IMetadataObject.)
	NoAutomaticRecomputation	Gets or sets a value that indicates whether statistics are regenerated when an index is created.
	PadIndex	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.)
	Parent	Gets the ITabular object that is the parent of this object. (Inherited from IIndex.)
	PartitionScheme	Gets or sets the partition scheme that is associated with the index.
	Type	Gets the type of the index. (Inherited from IIndex.)

Top

Methods

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

Top

See Also

Reference

Microsoft.SqlServer.Management.SqlParser.Metadata Namespace