Share via


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
Public property CompactLargeObjects Gets or sets a value that indicates whether to compact the large object (LOB) data in the index.
Public property CompactLargeObjects Gets a value that indicates whether to compact the large object (LOB) data in the index. (Inherited from IRelationalIndex.)
Public property DisallowPageLocks Gets or sets a value that indicates whether the index allows page locks.
Public property DisallowPageLocks Gets a value that indicates whether the index allows page locks. (Inherited from IRelationalIndex.)
Public property DisallowRowLocks Gets or sets a value that indicates whether the index allows row locks.
Public property DisallowRowLocks Gets a value that indicates whether the index allows row locks. (Inherited from IRelationalIndex.)
Public property FileGroup Gets or sets the filegroup in which the index pages are stored.
Public property FileGroup Gets the filegroup in which the index pages are stored. (Inherited from IRelationalIndex.)
Public property FileStreamFileGroup Gets or sets the filegroup of the index file stream.
Public property FileStreamFileGroup Gets the filegroup of the index file stream. (Inherited from IRelationalIndex.)
Public property FileStreamPartitionScheme Gets or sets the partition scheme name for the index.
Public property FileStreamPartitionScheme Gets the partition scheme name for the index. (Inherited from IRelationalIndex.)
Public property FillFactor Gets or sets the percentage of an index page to fill when the index is created or re-created.
Public property FillFactor Gets the percentage of an index page to fill when the index is created or re-created. (Inherited from IRelationalIndex.)
Public property FilterDefinition Gets or sets the index filter definition text.
Public property FilterDefinition Gets the index filter definition text. (Inherited from IRelationalIndex.)
Public property IgnoreDuplicateKeys Gets or sets a value that indicates whether the index ignores duplicate keys.
Public property IgnoreDuplicateKeys Gets a value that indicates whether the index ignores duplicate keys. (Inherited from IRelationalIndex.)
Public property IndexedColumns Gets the collection of columns that are participating in the index.
Public property IndexedColumns Gets the collection of columns that are participating in the index. (Inherited from IRelationalIndex.)
Public property IndexKey Gets or sets the index key that is associated with the index.
Public property IndexKey Gets the index key that is associated with the index. (Inherited from IRelationalIndex.)
Public property IsClustered Gets or sets a value that indicates whether the index is clustered.
Public property IsClustered Gets a value that indicates whether the index is clustered. (Inherited from IRelationalIndex.)
Public property IsDisabled Gets or sets a value that indicates whether the index is disabled.
Public property IsDisabled Gets a value that indicates whether the index is disabled. (Inherited from IRelationalIndex.)
Public property IsSystemNamed Gets or sets a value that indicates whether the index was named automatically by the system.
Public property IsSystemNamed Gets a value that indicates whether the index was named automatically by the system. (Inherited from IRelationalIndex.)
Public property IsUnique Gets or sets a value that indicates whether the index is unique.
Public property IsUnique Gets a value that indicates whether the index is unique. (Inherited from IRelationalIndex.)
Public property MaximumDegreeOfParallelism Gets the maximum number of processors that can be used when a query that uses the index is run.
Public property MaximumDegreeOfParallelism Gets the maximum number of processors that can be used when running a query that uses the index. (Inherited from IRelationalIndex.)
Public property Name Gets the name of the metadata object. (Inherited from IMetadataObject.)
Public property NoAutomaticRecomputation Gets or sets a value that indicates whether statistics are regenerated when an index is created.
Public property NoAutomaticRecomputation Gets a value that indicates whether statistics are regenerated when the index is created. (Inherited from IRelationalIndex.)
Public property OnlineIndexOperation Gets or sets a value that indicates whether the index will be kept online during index operations. This allows for to the data.
Public property OnlineIndexOperation Gets a value that indicates whether the index is kept online during index operations. This allows for access to the data. (Inherited from IRelationalIndex.)
Public property PadIndex Gets or sets a value that indicates whether space is left open on each page of the intermediate levels of the index.
Public property PadIndex Gets a value that indicates whether space is left open on each page of the intermediate levels of the index. (Inherited from IRelationalIndex.)
Public property Parent Gets the ITabular object that is the parent of this object. (Inherited from IIndex.)
Public property PartitionScheme Gets or sets the partition scheme that is associated with the index.
Public property PartitionScheme Gets the partition scheme that is associated with the index. (Inherited from IRelationalIndex.)
Public property SortInTempdb Gets or sets a value that indicates whether the index is sorted using the tempdb database for intermediate storage of data.
Public property SortInTempdb Gets a value that indicates whether the index is sorted using the tempdb database for intermediate storage of data. (Inherited from IRelationalIndex.)

Top

Methods

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

Top