Интерфейс IRelationalIndex

Represents a SQL Server relational index.

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

Синтаксис

'Декларация
Public Interface IRelationalIndex _
    Inherits IIndex, IMetadataObject
'Применение
Dim instance As IRelationalIndex
public interface IRelationalIndex : IIndex, 
    IMetadataObject
public interface class IRelationalIndex : IIndex, 
    IMetadataObject
type IRelationalIndex =  
    interface
        interface IIndex
        interface IMetadataObject
    end
public interface IRelationalIndex extends IIndex, IMetadataObject

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

Свойства

  Имя Описание
Открытое свойство CompactLargeObjects Gets a value that indicates whether to compact the large object (LOB) data in the index.
Открытое свойство DisallowPageLocks Gets a value that indicates whether the index allows page locks.
Открытое свойство DisallowRowLocks Gets a value that indicates whether the index allows row locks.
Открытое свойство FileGroup Gets the filegroup in which the index pages are stored.
Открытое свойство FileStreamFileGroup Gets the filegroup of the index file stream.
Открытое свойство FileStreamPartitionScheme Gets the partition scheme name for the index.
Открытое свойство FillFactor Gets the percentage of an index page to fill when the index is created or re-created.
Открытое свойство FilterDefinition Gets the index filter definition text.
Открытое свойство IgnoreDuplicateKeys Gets a value that indicates whether the index ignores duplicate keys.
Открытое свойство IndexedColumns Gets the collection of columns that are participating in the index.
Открытое свойство IndexKey Gets the index key that is associated with the index.
Открытое свойство IsClustered Gets a value that indicates whether the index is clustered.
Открытое свойство IsDisabled Gets a value that indicates whether the index is disabled.
Открытое свойство IsSystemNamed Gets a value that indicates whether the index was named automatically by the system.
Открытое свойство IsUnique Gets a value that indicates whether the index is unique.
Открытое свойство MaximumDegreeOfParallelism Gets the maximum number of processors that can be used when running a query that uses the index.
Открытое свойство Name Gets the name of the metadata object. (Производный от IMetadataObject.)
Открытое свойство NoAutomaticRecomputation Gets a value that indicates whether statistics are regenerated when the index is created.
Открытое свойство OnlineIndexOperation Gets a value that indicates whether the index is kept online during index operations. This allows for access to the data.
Открытое свойство PadIndex Gets a value that indicates whether space is left open on each page of the intermediate levels of the index.
Открытое свойство Parent Gets the ITabular object that is the parent of this object. (Производный от IIndex.)
Открытое свойство PartitionScheme Gets the partition scheme that is associated with the index.
Открытое свойство SortInTempdb Gets a value that indicates whether the index is sorted using the tempdb database for intermediate storage of data.

В начало

Методы

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

В начало