IRelationalIndex Interface

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

The IRelationalIndex type exposes the following members.

Properties

	Name	Description
	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. (Inherited from 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. (Inherited from 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.

Top

Methods

	Name	Description
	Accept<T>	Accepts a visit from the specified IMetadataObjectVisitor<T> object. (Inherited from IMetadataObject.)

Top

See Also

Reference

Microsoft.SqlServer.Management.SqlParser.Metadata Namespace