ISql90SpecifiesIndex Interface
Models index settings.
Namespace: Microsoft.Data.Schema.Sql.SchemaModel
Assembly: Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)
Syntax
'Declaration
Public Interface ISql90SpecifiesIndex _
Inherits ISqlSpecifiesIndex, ISql90SpecifiesStorage, ISqlSpecifiesStorage, ISqlModelElement, _
IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder
public interface ISql90SpecifiesIndex : ISqlSpecifiesIndex,
ISql90SpecifiesStorage, ISqlSpecifiesStorage, ISqlModelElement, IScriptSourcedModelElement, IModelElement,
IModelPropertyContainer, IModelEntity, IModelAnnotationHolder
public interface class ISql90SpecifiesIndex : ISqlSpecifiesIndex,
ISql90SpecifiesStorage, ISqlSpecifiesStorage, ISqlModelElement, IScriptSourcedModelElement, IModelElement,
IModelPropertyContainer, IModelEntity, IModelAnnotationHolder
type ISql90SpecifiesIndex =
interface
interface ISqlSpecifiesIndex
interface ISql90SpecifiesStorage
interface ISqlSpecifiesStorage
interface ISqlModelElement
interface IScriptSourcedModelElement
interface IModelElement
interface IModelPropertyContainer
interface IModelEntity
interface IModelAnnotationHolder
end
public interface ISql90SpecifiesIndex extends ISqlSpecifiesIndex, ISql90SpecifiesStorage, ISqlSpecifiesStorage, ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder
The ISql90SpecifiesIndex type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
ColumnSpecifications | Gets a list of the columns that are indexed. (Inherited from ISqlSpecifiesIndex.) |
|
DoAllowPageLocks | Gets or sets a value that indicates whether page-level locks are permitted. |
|
DoAllowRowLocks | Gets or sets a value that indicates whether row-level locks are permitted. |
|
DoIgnoreDuplicateKey | Gets or sets a value that indicates whether the index ignores duplicate keys. |
|
DoRecomputeStatistics | Gets or sets a value that models the STATISTICS_NORECOMPUTE option. |
|
DoSortInTempDB | Gets or sets a value that indicates whether the index is sorted in the TempDB database. |
|
ElementClass | Gets the metadata class for an element. (Inherited from IModelElement.) |
|
Filegroup | Gets or sets the filegroup on which the object is stored. (Inherited from ISqlSpecifiesStorage.) |
|
FillFactor | Gets or sets the fill factor of the index. (Inherited from ISqlSpecifiesIndex.) |
|
IsClustered | Gets or sets a value that indicates whether this is a clustered index. (Inherited from ISqlSpecifiesIndex.) |
|
IsOnline | Gets or sets a value that indicates whether the index is online and available. |
|
IsPadded | Gets or sets a value that indicates whether the index is padded. |
|
MaxDop | Gets or sets a value that models the MAXDOP option. |
|
Model | Gets the model reference. (Inherited from IModelEntity.) |
|
Name | Gets or sets the name of the element. (Inherited from IModelElement.) |
|
PartitionColumn | Gets or sets the column on which to partition the object. (Inherited from ISql90SpecifiesStorage.) |
|
PartitionScheme | Gets or sets the partition scheme that is used to store the object. (Inherited from ISql90SpecifiesStorage.) |
|
PrimarySource | Gets information about the primary source for the element. (Inherited from IScriptSourcedModelElement.) |
|
ResolutionStatus | Gets or sets the value of the model element resolution status. (Inherited from IModelElement.) |
|
SecondarySources | Gets a list of secondary sources for the element. (Inherited from IScriptSourcedModelElement.) |
|
SourceCodePositions | Gets the list of sources that define this element. (Inherited from IModelElement.) |
|
ValidationStatus | Gets or sets the value of the model element validation status. (Inherited from IModelElement.) |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
AddAnnotation | Adds the given annotation to this element. (Inherited from IModelAnnotationHolder.) |
|
Delete | Deletes this instance from the model. (Inherited from IModelElement.) |
|
GetAnnotations() | Returns a list of annotations attached to this element. (Inherited from IModelAnnotationHolder.) |
|
GetAnnotations(Type) | Returns a list of attached annotations of the given type. (Inherited from IModelAnnotationHolder.) |
|
GetAnnotations(ModelIdentifier) | Returns a list of attached annotations that have the given identifier. (Inherited from IModelAnnotationHolder.) |
|
GetAnnotations(ModelIdentifier, Type) | (Inherited from IModelAnnotationHolder.) |
|
GetAnnotations<TType>() | Returns all attached model annotations that implement the given annotation type and have the specified model identifier. (Inherited from IModelAnnotationHolder.) |
|
GetAnnotations<TType>(ModelIdentifier) | (Inherited from IModelAnnotationHolder.) |
|
GetColumnSpecificationsRelationship | Returns an IModelMultiRelationship between this and the associated ISqlIndexedColumnSpecification. (Inherited from ISqlSpecifiesIndex.) |
|
GetComposingChildren | Returns a list of composing children for this element. (Inherited from IModelElement.) |
|
GetFilegroupRelationship | Returns an IModelSingleRelationship between this and the associated ISqlFilegroup. (Inherited from ISqlSpecifiesStorage.) |
|
GetHierarchicalChildren | Returns a list of hierarchical children for this element. (Inherited from IModelElement.) |
|
GetOwnerInfo | Returns information about the element owner. (Inherited from IModelElement.) |
|
GetPartitionColumnRelationship | Returns an IModelSingleRelationship between this and the associated ISqlColumn. (Inherited from ISql90SpecifiesStorage.) |
|
GetPartitionSchemeRelationship | Returns an IModelSingleRelationship between this and the associated ISql90PartitionScheme. (Inherited from ISql90SpecifiesStorage.) |
|
GetProperty<TProperty> | Gets the specified property. (Inherited from IModelPropertyContainer.) |
|
GetReferencedDanglingRelationshipEntries | Returns a list of the relationship entries, where this element is on the left side and there is either no element on the right side of the relationship, or the element on the right does not exist in the model. (Inherited from IModelElement.) |
|
GetReferencedElements | Returns a list of the elements that are in a relationship with this element, where this element is on the left side of the relationship. (Inherited from IModelElement.) |
|
GetReferencedRelationshipEntries | Returns a list of the relationship entries, where this element is on the left side. (Inherited from IModelElement.) |
|
GetReferencingElements | Returns a list of the elements that are in a relationship with this element, where this element is on the right side. (Inherited from IModelElement.) |
|
GetReferencingRelationshipEntries | Returns a list of the relationship entries, where this element is on the right side. (Inherited from IModelElement.) |
|
GetRelationship(ModelRelationshipClass) | Returns the requested relationship by using the provided metadata. (Inherited from IModelElement.) |
|
GetRelationship<TFrom, TTo>(ModelRelationshipClass) | Returns a relationship where the two related elements are of the specified types. (Inherited from IModelElement.) |
|
GetRelationshipEntrySources | Returns a collection of source information about the given relationship. (Inherited from IScriptSourcedModelElement.) |
|
GetRelationships | Returns a list of the relationships in this element. (Inherited from IModelElement.) |
|
IsDeleted | Specifies whether the object is deleted. (Inherited from IModelElement.) |
|
IsExternal | Returns a value that indicates whether the object was loaded from an external source and is not a part of the schema model. (Inherited from IModelElement.) |
|
RemoveAnnotation | Removes the specified annotation from this model element. (Inherited from IModelAnnotationHolder.) |
|
SetProperty<TProperty> | Sets the specified property. (Inherited from IModelPropertyContainer.) |
Top