Freigeben über


IRelationalIndex-Schnittstelle

Represents a 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 IRelationalIndex _
    Inherits IIndex, IMetadataObject
'Usage
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

Der IRelationalIndex-Typ macht folgende Elemente verfügbar.

Eigenschaften

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

Zum Anfang

Methoden

  Name Beschreibung
Öffentliche Methode Accept< (Of < <' (T> ) > > ) Accepts a visit from the specified IMetadataObjectVisitor<(Of <(<'T>)>)> object. (Geerbt von IMetadataObject.)

Zum Anfang