IMutableRelationalIndex Interface
Represents a mutable 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 IMutableRelationalIndex _
Inherits IRelationalIndex, IMutableIndex, IIndex, IMutableMetadataObject, _
IMetadataObject
'Usage
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
The IMutableRelationalIndex type exposes the following members.
Properties
Name | Description | |
---|---|---|
CompactLargeObjects | Gets or sets a value that indicates whether to compact the large object (LOB) data in the index. | |
CompactLargeObjects | Gets a value that indicates whether to compact the large object (LOB) data in the index. (Inherited from IRelationalIndex.) | |
DisallowPageLocks | Gets or sets a value that indicates whether the index allows page locks. | |
DisallowPageLocks | Gets a value that indicates whether the index allows page locks. (Inherited from IRelationalIndex.) | |
DisallowRowLocks | Gets or sets a value that indicates whether the index allows row locks. | |
DisallowRowLocks | Gets a value that indicates whether the index allows row locks. (Inherited from IRelationalIndex.) | |
FileGroup | Gets or sets the filegroup in which the index pages are stored. | |
FileGroup | Gets the filegroup in which the index pages are stored. (Inherited from IRelationalIndex.) | |
FileStreamFileGroup | Gets or sets the filegroup of the index file stream. | |
FileStreamFileGroup | Gets the filegroup of the index file stream. (Inherited from IRelationalIndex.) | |
FileStreamPartitionScheme | Gets or sets the partition scheme name for the index. | |
FileStreamPartitionScheme | Gets the partition scheme name for the index. (Inherited from IRelationalIndex.) | |
FillFactor | Gets or sets the percentage of an index page to fill when the index is created or re-created. | |
FillFactor | Gets the percentage of an index page to fill when the index is created or re-created. (Inherited from IRelationalIndex.) | |
FilterDefinition | Gets or sets the index filter definition text. | |
FilterDefinition | Gets the index filter definition text. (Inherited from IRelationalIndex.) | |
IgnoreDuplicateKeys | Gets or sets a value that indicates whether the index ignores duplicate keys. | |
IgnoreDuplicateKeys | Gets a value that indicates whether the index ignores duplicate keys. (Inherited from IRelationalIndex.) | |
IndexedColumns | Gets the collection of columns that are participating in the index. | |
IndexedColumns | Gets the collection of columns that are participating in the index. (Inherited from IRelationalIndex.) | |
IndexKey | Gets or sets the index key that is associated with the index. | |
IndexKey | Gets the index key that is associated with the index. (Inherited from IRelationalIndex.) | |
IsClustered | Gets or sets a value that indicates whether the index is clustered. | |
IsClustered | Gets a value that indicates whether the index is clustered. (Inherited from IRelationalIndex.) | |
IsDisabled | Gets or sets a value that indicates whether the index is disabled. | |
IsDisabled | Gets a value that indicates whether the index is disabled. (Inherited from IRelationalIndex.) | |
IsSystemNamed | Gets or sets a value that indicates whether the index was named automatically by the system. | |
IsSystemNamed | Gets a value that indicates whether the index was named automatically by the system. (Inherited from IRelationalIndex.) | |
IsUnique | Gets or sets a value that indicates whether the index is unique. | |
IsUnique | Gets a value that indicates whether the index is unique. (Inherited from IRelationalIndex.) | |
MaximumDegreeOfParallelism | Gets the maximum number of processors that can be used when a query that uses the index is run. | |
MaximumDegreeOfParallelism | Gets the maximum number of processors that can be used when running a query that uses the index. (Inherited from IRelationalIndex.) | |
Name | Gets the name of the metadata object. (Inherited from IMetadataObject.) | |
NoAutomaticRecomputation | Gets or sets a value that indicates whether statistics are regenerated when an index is created. | |
NoAutomaticRecomputation | Gets a value that indicates whether statistics are regenerated when the index is created. (Inherited from IRelationalIndex.) | |
OnlineIndexOperation | Gets or sets a value that indicates whether the index will be kept online during index operations. This allows for to the data. | |
OnlineIndexOperation | Gets a value that indicates whether the index is kept online during index operations. This allows for access to the data. (Inherited from IRelationalIndex.) | |
PadIndex | Gets or sets a value that indicates whether space is left open on each page of the intermediate levels of the index. | |
PadIndex | Gets a value that indicates whether space is left open on each page of the intermediate levels of the index. (Inherited from IRelationalIndex.) | |
Parent | Gets the ITabular object that is the parent of this object. (Inherited from IIndex.) | |
PartitionScheme | Gets or sets the partition scheme that is associated with the index. | |
PartitionScheme | Gets the partition scheme that is associated with the index. (Inherited from IRelationalIndex.) | |
SortInTempdb | Gets or sets a value that indicates whether the index is sorted using the tempdb database for intermediate storage of data. | |
SortInTempdb | Gets a value that indicates whether the index is sorted using the tempdb database for intermediate storage of data. (Inherited from IRelationalIndex.) |
Top
Methods
Name | Description | |
---|---|---|
Accept<T> | Accepts a visit from the specified IMetadataObjectVisitor<T> object. (Inherited from IMetadataObject.) |
Top