다음을 통해 공유


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에서 상속됨)

맨 위로 이동