Export (0) Print
Expand All

ISql90Index Interface

Visual Studio 2010

Models an index.

Namespace:  Microsoft.Data.Schema.Sql.SchemaModel
Assembly:  Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)

public interface ISql90Index : ISqlIndex, 
	ISqlIndexBase, IDatabaseIndex, IModelNamed, ISqlExtendedPropertyHost, ISql90SpecifiesIndex, 
	ISqlSpecifiesIndex, ISql90SpecifiesStorage, ISqlSpecifiesStorage, ISqlModelElement, IScriptSourcedModelElement, 
	IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

The ISql90Index type exposes the following members.

  NameDescription
Public propertyColumnSpecificationsGets a list of the columns that are indexed. (Inherited from ISqlSpecifiesIndex.)
Public propertyDoAllowPageLocksGets or sets a value that indicates whether page-level locks are permitted.
Public propertyDoAllowPageLocksGets or sets a value that indicates whether page-level locks are permitted. (Inherited from ISql90SpecifiesIndex.)
Public propertyDoAllowPageLocksGets or sets a value that indicates whether page-level locks are permitted. (Inherited from ISqlIndex.)
Public propertyDoAllowRowLocksGets or sets a value that indicates whether row-level locks are permitted.
Public propertyDoAllowRowLocksGets or sets a value that indicates whether row-level locks are permitted. (Inherited from ISql90SpecifiesIndex.)
Public propertyDoAllowRowLocksGets or sets a value that indicates whether row locks should be permitted. (Inherited from ISqlIndex.)
Public propertyDoDropExistingGets or sets a value that models the DROP_EXISTING option. (Inherited from ISqlIndex.)
Public propertyDoIgnoreDuplicateKeyGets or sets a value that indicates whether the index ignores duplicate keys.
Public propertyDoIgnoreDuplicateKeyGets or sets a value that indicates whether the index ignores duplicate keys. (Inherited from ISql90SpecifiesIndex.)
Public propertyDoIgnoreDuplicateKeyGets or sets a value that indicates whether duplicate keys should be ignored. (Inherited from ISqlIndex.)
Public propertyDoRecomputeStatisticsGets or sets a value that models the STATISTICS_NORECOMPUTE setting.
Public propertyDoRecomputeStatisticsGets or sets a value that models the STATISTICS_NORECOMPUTE option. (Inherited from ISql90SpecifiesIndex.)
Public propertyDoRecomputeStatisticsGets or sets a value that indicates whether statistics should be recomputed. (Inherited from ISqlIndex.)
Public propertyDoSortInTempDBGets or sets a value that indicates whether sorts for this index are performed in the TempDB database.
Public propertyDoSortInTempDBGets or sets a value that indicates whether the index is sorted in the TempDB database. (Inherited from ISql90SpecifiesIndex.)
Public propertyDoSortInTempDBGets or sets a value that indicates whether sorting should occur in the TempDB database. (Inherited from ISqlIndex.)
Public propertyElementClassGets the metadata class for an element. (Inherited from IModelElement.)
Public propertyExtendedPropertiesGets the list of extended properties for this object. (Inherited from ISqlExtendedPropertyHost.)
Public propertyFilegroupGets or sets the filegroup on which the object is stored. (Inherited from ISqlSpecifiesStorage.)
Public propertyFillFactorGets or sets the fill factor of the index. (Inherited from ISqlSpecifiesIndex.)
Public propertyIncludedColumnsGets the list of columns to be indexed.
Public propertyIndexedObjectThe object that is indexed. (Inherited from IDatabaseIndex.)
Public propertyIndexedObjectGets or sets the indexed object. (Inherited from ISqlIndex.)
Public propertyIsClusteredGets or sets a value that indicates whether this is a clustered index. (Inherited from ISqlSpecifiesIndex.)
Public propertyIsDisabledGets or sets a value that indicates whether the index is disabled. (Inherited from ISqlIndexBase.)
Public propertyIsOnlineGets or sets a value that indicates whether the index is online and available.
Public propertyIsOnlineGets or sets a value that indicates whether the index is online and available. (Inherited from ISql90SpecifiesIndex.)
Public propertyIsPaddedGets or sets a value that indicates whether the index is padded.
Public propertyIsPaddedGets or sets a value that indicates whether the index is padded. (Inherited from ISql90SpecifiesIndex.)
Public propertyIsPaddedGets or sets a value that indicates whether the index is padded. (Inherited from ISqlIndex.)
Public propertyIsUniqueGets or sets a value that indicates whether the index is a unique index. (Inherited from ISqlIndex.)
Public propertyMaxDopGets or sets a value that models the MAXDOP setting.
Public propertyMaxDopGets or sets a value that models the MAXDOP option. (Inherited from ISql90SpecifiesIndex.)
Public propertyModelGets the model reference. (Inherited from IModelEntity.)
Public propertyNameGets or sets the name of the element. (Inherited from IModelElement.)
Public propertyPartitionColumnGets or sets the column on which to partition the object. (Inherited from ISql90SpecifiesStorage.)
Public propertyPartitionSchemeGets or sets the partition scheme that is used to store the object. (Inherited from ISql90SpecifiesStorage.)
Public propertyPrimarySourceGets information about the primary source for the element. (Inherited from IScriptSourcedModelElement.)
Public propertyResolutionStatusGets or sets the value of the model element resolution status. (Inherited from IModelElement.)
Public propertySecondarySourcesGets a list of secondary sources for the element. (Inherited from IScriptSourcedModelElement.)
Public propertySourceCodePositionsGets the list of sources that define this element. (Inherited from IModelElement.)
Public propertyValidationStatusGets or sets the value of the model element validation status. (Inherited from IModelElement.)
Top

  NameDescription
Public methodAddAnnotationAdds the given annotation to this element. (Inherited from IModelAnnotationHolder.)
Public methodDeleteDeletes this instance from the model. (Inherited from IModelElement.)
Public methodGetAnnotations()Returns a list of annotations attached to this element. (Inherited from IModelAnnotationHolder.)
Public methodGetAnnotations(Type)Returns a list of attached annotations of the given type. (Inherited from IModelAnnotationHolder.)
Public methodGetAnnotations(ModelIdentifier)Returns a list of attached annotations that have the given identifier. (Inherited from IModelAnnotationHolder.)
Public methodGetAnnotations(ModelIdentifier, Type) (Inherited from IModelAnnotationHolder.)
Public methodGetAnnotations<TType>()Returns all attached model annotations that implement the given annotation type and have the specified model identifier. (Inherited from IModelAnnotationHolder.)
Public methodGetAnnotations<TType>(ModelIdentifier) (Inherited from IModelAnnotationHolder.)
Public methodGetColumnSpecificationsRelationshipReturns an IModelMultiRelationship between this and the associated ISqlIndexedColumnSpecification. (Inherited from ISqlSpecifiesIndex.)
Public methodGetComposingChildrenReturns a list of composing children for this element. (Inherited from IModelElement.)
Public methodGetExtendedPropertiesRelationshipReturns an IModelReverseMultiRelationship between this and the associated ISqlExtendedProperty. (Inherited from ISqlExtendedPropertyHost.)
Public methodGetFilegroupRelationshipReturns an IModelSingleRelationship between this and the associated ISqlFilegroup. (Inherited from ISqlSpecifiesStorage.)
Public methodGetHierarchicalChildrenReturns a list of hierarchical children for this element. (Inherited from IModelElement.)
Public methodGetIncludedColumnsRelationshipReturns an IModelMultiRelationship between this and the associated ISqlColumn.
Public methodGetIndexedObjectRelationship()Returns the IModelSingleRelationship between this IDatabaseIndex and the corresponding IDatabaseColumnSource. (Inherited from IDatabaseIndex.)
Public methodGetIndexedObjectRelationship()Returns an IModelSingleRelationship between this and the associated ISqlColumnSource. (Inherited from ISqlIndex.)
Public methodGetOwnerInfoReturns information about the element owner. (Inherited from IModelElement.)
Public methodGetPartitionColumnRelationshipReturns an IModelSingleRelationship between this and the associated ISqlColumn. (Inherited from ISql90SpecifiesStorage.)
Public methodGetPartitionSchemeRelationshipReturns an IModelSingleRelationship between this and the associated ISql90PartitionScheme. (Inherited from ISql90SpecifiesStorage.)
Public methodGetProperty<TProperty>Gets the specified property. (Inherited from IModelPropertyContainer.)
Public methodGetReferencedDanglingRelationshipEntriesReturns 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.)
Public methodGetReferencedElementsReturns 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.)
Public methodGetReferencedRelationshipEntriesReturns a list of the relationship entries, where this element is on the left side. (Inherited from IModelElement.)
Public methodGetReferencingElementsReturns a list of the elements that are in a relationship with this element, where this element is on the right side. (Inherited from IModelElement.)
Public methodGetReferencingRelationshipEntriesReturns a list of the relationship entries, where this element is on the right side. (Inherited from IModelElement.)
Public methodGetRelationship(ModelRelationshipClass)Returns the requested relationship by using the provided metadata. (Inherited from IModelElement.)
Public methodGetRelationship<TFrom, TTo>(ModelRelationshipClass)Returns a relationship where the two related elements are of the specified types. (Inherited from IModelElement.)
Public methodGetRelationshipEntrySourcesReturns a collection of source information about the given relationship. (Inherited from IScriptSourcedModelElement.)
Public methodGetRelationshipsReturns a list of the relationships in this element. (Inherited from IModelElement.)
Public methodIsDeletedSpecifies whether the object is deleted. (Inherited from IModelElement.)
Public methodIsExternalReturns 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.)
Public methodRemoveAnnotationRemoves the specified annotation from this model element. (Inherited from IModelAnnotationHolder.)
Public methodSetProperty<TProperty>Sets the specified property. (Inherited from IModelPropertyContainer.)
Top

Community Additions

ADD
Show:
© 2015 Microsoft