Partager via


Interface IMutableRelationalIndex

Represents a mutable 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 IMutableRelationalIndex _
    Inherits IRelationalIndex, IMutableIndex, IIndex, IMutableMetadataObject,  _
    IMetadataObject
'Utilisation
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

Le type IMutableRelationalIndex expose les membres suivants.

Propriétés

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

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