Partager via


Interface IRelationalIndex

Represents a SQL Server relational index.

Espace de noms :  Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly :  Microsoft.SqlServer.Management.SqlParser (en Microsoft.SqlServer.Management.SqlParser.dll)

Syntaxe

'Déclaration
Public Interface IRelationalIndex _
    Inherits IIndex, IMetadataObject
'Utilisation
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

Le type IRelationalIndex expose les membres suivants.

Propriétés

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

Haut de la page

Méthodes

  Nom Description
Méthode publique Accept< (Of < <' (T> ) > > ) Accepts a visit from the specified IMetadataObjectVisitor<(Of <(<'T>)>)> object. (hérité de IMetadataObject.)

Haut de la page