Интерфейс IMutableRelationalIndex

Represents a mutable SQL Server relational index.

Пространство имен:  Microsoft.SqlServer.Management.SqlParser.Metadata
Сборка:  Microsoft.SqlServer.Management.SqlParser (в Microsoft.SqlServer.Management.SqlParser.dll)

Синтаксис

'Декларация
Public Interface IMutableRelationalIndex _
    Inherits IRelationalIndex, IMutableIndex, IIndex, IMutableMetadataObject,  _
    IMetadataObject
'Применение
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

Тип IMutableRelationalIndex обеспечивает доступ к следующим элементам.

Свойства

  Имя Описание
Открытое свойство 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. (Производный от 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. (Производный от 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. (Производный от 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. (Производный от IRelationalIndex.)
Открытое свойство FileStreamFileGroup Gets or sets the filegroup of the index file stream.
Открытое свойство FileStreamFileGroup Gets the filegroup of the index file stream. (Производный от IRelationalIndex.)
Открытое свойство FileStreamPartitionScheme Gets or sets the partition scheme name for the index.
Открытое свойство FileStreamPartitionScheme Gets the partition scheme name for the index. (Производный от 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. (Производный от IRelationalIndex.)
Открытое свойство FilterDefinition Gets or sets the index filter definition text.
Открытое свойство FilterDefinition Gets the index filter definition text. (Производный от 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. (Производный от 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. (Производный от 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. (Производный от 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. (Производный от 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. (Производный от 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. (Производный от 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. (Производный от 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. (Производный от IRelationalIndex.)
Открытое свойство Name Gets the name of the metadata object. (Производный от 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. (Производный от 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. (Производный от 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. (Производный от IRelationalIndex.)
Открытое свойство Parent Gets the ITabular object that is the parent of this object. (Производный от 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. (Производный от 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. (Производный от IRelationalIndex.)

В начало

Методы

  Имя Описание
Открытый метод Accept< (Of < <' (T> ) > > ) Accepts a visit from the specified IMetadataObjectVisitor<(Of <(<'T>)>)> object. (Производный от IMetadataObject.)

В начало