Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ISql90Table Interface

Visual Studio 2010

Models a table.

Namespace:  Microsoft.Data.Schema.Sql.SchemaModel
Assembly:  Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)
public interface ISql90Table : ISqlTable, 
	IDatabaseTable, IModelNamed, ISqlOwnedObject, ISqlExtendedPropertyHost, ISqlSecurable, 
	ISqlColumnSource, IDatabaseColumnSource, ISqlStatisticBound, ISqlFulltextIndexedObject, ISqlSpecifiesAnsiNulls, 
	ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISql90SpecifiesStorage, ISqlSpecifiesStorage, ISql90SynonymTarget, 
	ISql90SpecifiesTable, ISqlSpecifiesTable, ISql90XmlIndexedObject, ISqlModelElement, IScriptSourcedModelElement, 
	IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

The ISql90Table type exposes the following members.

  NameDescription
Public propertyColumnsGets the columns for this IDatabaseColumnSource. (Inherited from IDatabaseColumnSource.)
Public propertyColumnsGets the list of the columns that are provided by this source. (Inherited from ISqlColumnSource.)
Public propertyConstraintsGets the list of constraints that apply to the object. (Inherited from ISql90SpecifiesTable.)
Public propertyConstraintsGets the list of constraints that apply to the object. (Inherited from ISqlSpecifiesTable.)
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 propertyFilegroupForTextImageGets or sets a value that models the TEXTIMAGE_ON option. (Inherited from ISqlTable.)
Public propertyFullTextIndexGets the list of full-text indexes that apply to this object. (Inherited from ISqlFulltextIndexedObject.)
Public propertyIndexesGets the indexes that apply to this IDatabaseColumnSource. (Inherited from IDatabaseColumnSource.)
Public propertyIndexesGets the list of the indexes that involve this source. (Inherited from ISqlColumnSource.)
Public propertyIsAnsiNullsOnGets or sets a value that indicates whether the ANSI NULLS setting is ON for this object. (Inherited from ISqlSpecifiesAnsiNulls.)
Public propertyIsLargeValueTypesOutOfRowGets or sets a value that is used to control the in-row behavior of tables that have varchar(max), nvarchar(max), varbinary(max), xml, text, ntext, image, or large user-defined type columns.
Public propertyIsQuotedIdentifierOnGets or sets a value that indicates whether the QUOTED IDENTIFIER setting is ON for this object. (Inherited from ISqlSpecifiesQuotedIdentifier.)
Public propertyIsReplicatedGets or sets a value that indicates whether the object is subject to replication. (Inherited from ISqlSupportsReplication.)
Public propertyIsTableLockOnBulkLoadGets or sets a value that models the "table lock on bulk load" sp_tableoption option. (Inherited from ISqlTable.)
Public propertyIsVardecimalStorageFormatOnGets or sets a value that indicates whether the vardecimal storage is enabled for the table.
Public propertyModelGets the model reference. (Inherited from IModelEntity.)
Public propertyNameGets or sets the name of the element. (Inherited from IModelElement.)
Public propertyOwnerGets or sets the owner of this object. (Inherited from ISqlOwnedObject.)
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 propertyPermissionsGets the list of permissions that apply to this object. (Inherited from ISqlSecurable.)
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 propertyStatisticsGets the list of statistics that apply to this object. (Inherited from ISqlStatisticBound.)
Public propertySynonymsGets the list of synonyms that are associated with this target. (Inherited from ISql90SynonymTarget.)
Public propertyTextInRowSizeGets or sets a value that models the "text in row" sp_tableoption option. (Inherited from ISqlTable.)
Public propertyTriggersGets the list of the Data Manipulation Language (DML) triggers that involve this source. (Inherited from ISqlColumnSource.)
Public propertyValidationStatusGets or sets the value of the model element validation status. (Inherited from IModelElement.)
Public propertyXmlIndexGets the list of XML indexes that are associated with this object. (Inherited from ISql90XmlIndexedObject.)
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 methodGetColumnsRelationship()Returns the IModelMultiRelationship between this IDatabaseColumnSource and the associated IDatabaseColumn instances. (Inherited from IDatabaseColumnSource.)
Public methodGetColumnsRelationship()Returns an IModelMultiRelationship between this and the associated ISqlColumn. (Inherited from ISqlColumnSource.)
Public methodGetComposingChildrenReturns a list of composing children for this element. (Inherited from IModelElement.)
Public methodGetConstraintsRelationship()Returns an IModelReverseMultiRelationship between this and the associated ISql90Constraint. (Inherited from ISql90SpecifiesTable.)
Public methodGetConstraintsRelationship()Returns an IModelReverseMultiRelationship between this and the associated ISqlConstraint. (Inherited from ISqlSpecifiesTable.)
Public methodGetExtendedPropertiesRelationshipReturns an IModelReverseMultiRelationship between this and the associated ISqlExtendedProperty. (Inherited from ISqlExtendedPropertyHost.)
Public methodGetFilegroupForTextImageRelationshipReturns an IModelSingleRelationship between this and the associated ISqlFilegroup. (Inherited from ISqlTable.)
Public methodGetFilegroupRelationshipReturns an IModelSingleRelationship between this and the associated ISqlFilegroup. (Inherited from ISqlSpecifiesStorage.)
Public methodGetFullTextIndexRelationshipReturns an IModelReverseMultiRelationship between this and the associated ISqlFullTextIndex. (Inherited from ISqlFulltextIndexedObject.)
Public methodGetHierarchicalChildrenReturns a list of hierarchical children for this element. (Inherited from IModelElement.)
Public methodGetIndexesRelationship()Returns the IModelReverseMultiRelationship between this IDatabaseColumnSource and any associated IDatabaseIndex instances. (Inherited from IDatabaseColumnSource.)
Public methodGetIndexesRelationship()Returns an IModelReverseMultiRelationship between this and the associated ISqlIndex. (Inherited from ISqlColumnSource.)
Public methodGetOwnerInfoReturns information about the element owner. (Inherited from IModelElement.)
Public methodGetOwnerRelationshipReturns an IModelSingleRelationship between this and the associated ISqlObjectOwner. (Inherited from ISqlOwnedObject.)
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 methodGetPermissionsRelationshipReturns an IModelReverseMultiRelationship between this and the associated ISqlPermissionStatement. (Inherited from ISqlSecurable.)
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 methodGetStatisticsRelationshipReturns an IModelReverseMultiRelationship between this and the associated ISqlStatistic. (Inherited from ISqlStatisticBound.)
Public methodGetSynonymsRelationshipReturns an IModelReverseMultiRelationship between this and the associated ISql90Synonym. (Inherited from ISql90SynonymTarget.)
Public methodGetTriggersRelationshipReturns an IModelReverseMultiRelationship between this and the associated ISqlDmlTrigger. (Inherited from ISqlColumnSource.)
Public methodGetXmlIndexRelationshipReturns an IModelReverseMultiRelationship between this and the associated ISql90XmlIndex. (Inherited from ISql90XmlIndexedObject.)
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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.