Artigo
04/01/2012

Interface IMutableRelationalIndex

Represents a mutable SQL Server relational index.

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

Sintaxe

'Declaração
Public Interface IMutableRelationalIndex _
    Inherits IRelationalIndex, IMutableIndex, IIndex, IMutableMetadataObject,  _
    IMetadataObject
'Uso
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

O tipo IMutableRelationalIndex expõe os membros a seguir.

Propriedades

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