ISql100Table Interface

  • Article

Models a table.

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

Syntax

'Declaration
Public Interface ISql100Table _
    Inherits ISql90Table, ISqlTable, IDatabaseTable, IModelNamed,  _
    ISqlOwnedObject, ISqlExtendedPropertyHost, ISqlSecurable, ISqlColumnSource, IDatabaseColumnSource,  _
    ISqlStatisticBound, ISqlFulltextIndexedObject, ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication,  _
    ISql90SpecifiesStorage, ISqlSpecifiesStorage, ISql90SynonymTarget, ISql90SpecifiesTable, ISqlSpecifiesTable,  _
    ISql90XmlIndexedObject, ISql100SpatialIndexedObject, ISql100SpecifiesFileStream, ISql100SpecifiesDataCompressionOptions, ISqlModelElement,  _
    IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

public interface ISql100Table : ISql90Table, 
    ISqlTable, IDatabaseTable, IModelNamed, ISqlOwnedObject, ISqlExtendedPropertyHost, 
    ISqlSecurable, ISqlColumnSource, IDatabaseColumnSource, ISqlStatisticBound, ISqlFulltextIndexedObject, 
    ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISql90SpecifiesStorage, ISqlSpecifiesStorage, 
    ISql90SynonymTarget, ISql90SpecifiesTable, ISqlSpecifiesTable, ISql90XmlIndexedObject, ISql100SpatialIndexedObject, 
    ISql100SpecifiesFileStream, ISql100SpecifiesDataCompressionOptions, ISqlModelElement, IScriptSourcedModelElement, IModelElement, 
    IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

public interface class ISql100Table : ISql90Table, 
    ISqlTable, IDatabaseTable, IModelNamed, ISqlOwnedObject, ISqlExtendedPropertyHost, 
    ISqlSecurable, ISqlColumnSource, IDatabaseColumnSource, ISqlStatisticBound, ISqlFulltextIndexedObject, 
    ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISql90SpecifiesStorage, ISqlSpecifiesStorage, 
    ISql90SynonymTarget, ISql90SpecifiesTable, ISqlSpecifiesTable, ISql90XmlIndexedObject, ISql100SpatialIndexedObject, 
    ISql100SpecifiesFileStream, ISql100SpecifiesDataCompressionOptions, ISqlModelElement, IScriptSourcedModelElement, IModelElement, 
    IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

type ISql100Table =  
    interface
        interface ISql90Table
        interface ISqlTable
        interface IDatabaseTable
        interface IModelNamed
        interface ISqlOwnedObject
        interface ISqlExtendedPropertyHost
        interface ISqlSecurable
        interface ISqlColumnSource
        interface IDatabaseColumnSource
        interface ISqlStatisticBound
        interface ISqlFulltextIndexedObject
        interface ISqlSpecifiesAnsiNulls
        interface ISqlSpecifiesQuotedIdentifier
        interface ISqlSupportsReplication
        interface ISql90SpecifiesStorage
        interface ISqlSpecifiesStorage
        interface ISql90SynonymTarget
        interface ISql90SpecifiesTable
        interface ISqlSpecifiesTable
        interface ISql90XmlIndexedObject
        interface ISql100SpatialIndexedObject
        interface ISql100SpecifiesFileStream
        interface ISql100SpecifiesDataCompressionOptions
        interface ISqlModelElement
        interface IScriptSourcedModelElement
        interface IModelElement
        interface IModelPropertyContainer
        interface IModelEntity
        interface IModelAnnotationHolder
    end

public interface ISql100Table extends ISql90Table, ISqlTable, IDatabaseTable, IModelNamed, ISqlOwnedObject, ISqlExtendedPropertyHost, ISqlSecurable, ISqlColumnSource, IDatabaseColumnSource, ISqlStatisticBound, ISqlFulltextIndexedObject, ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISql90SpecifiesStorage, ISqlSpecifiesStorage, ISql90SynonymTarget, ISql90SpecifiesTable, ISqlSpecifiesTable, ISql90XmlIndexedObject, ISql100SpatialIndexedObject, ISql100SpecifiesFileStream, ISql100SpecifiesDataCompressionOptions, ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

The ISql100Table type exposes the following members.

Properties

  Name Description
Public property Columns Gets the columns for this IDatabaseColumnSource. (Inherited from IDatabaseColumnSource.)
Public property Columns Gets the list of the columns that are provided by this source. (Inherited from ISqlColumnSource.)
Public property Constraints Gets the list of constraints that apply to the object. (Inherited from ISql90SpecifiesTable.)
Public property Constraints Gets the list of constraints that apply to the object. (Inherited from ISqlSpecifiesTable.)
Public property DataCompressionOptions Gets the list of data compression options. (Inherited from ISql100SpecifiesDataCompressionOptions.)
Public property DynamicObjectForChangeTable Gets or sets the column source that results when CHANGETABLE is called on this table, for use in model resolution.
Public property ElementClass Gets the metadata class for an element. (Inherited from IModelElement.)
Public property ExtendedProperties Gets the list of extended properties for this object. (Inherited from ISqlExtendedPropertyHost.)
Public property Filegroup Gets or sets the filegroup on which the object is stored. (Inherited from ISqlSpecifiesStorage.)
Public property FilegroupForTextImage Gets or sets a value that models the TEXTIMAGE_ON option. (Inherited from ISqlTable.)
Public property FileStreamFilegroup Gets or sets the filegroup that stores the filestream objects of the object. (Inherited from ISql100SpecifiesFileStream.)
Public property FileStreamPartitionScheme Gets or sets the partition scheme to store the object. (Inherited from ISql100SpecifiesFileStream.)
Public property FullTextIndex Gets the list of full-text indexes that apply to this object. (Inherited from ISqlFulltextIndexedObject.)
Public property Indexes Gets the indexes that apply to this IDatabaseColumnSource. (Inherited from IDatabaseColumnSource.)
Public property Indexes Gets the list of the indexes that involve this source. (Inherited from ISqlColumnSource.)
Public property IsAnsiNullsOn Gets or sets a value that indicates whether the ANSI NULLS setting is ON for this object. (Inherited from ISqlSpecifiesAnsiNulls.)
Public property IsChangeDataCaptureOn Gets or sets a value that indicates whether change data capture is enabled for this table.
Public property IsChangeTrackingOn Gets or sets a value that indicates whether change tracking is enabled for this table.
Public property IsFileStreamNull Gets or sets a value that models the FILESTREAM_ON option. (Inherited from ISql100SpecifiesFileStream.)
Public property IsLargeValueTypesOutOfRow Gets 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. (Inherited from ISql90Table.)
Public property IsQuotedIdentifierOn Gets or sets a value that indicates whether the QUOTED IDENTIFIER setting is ON for this object. (Inherited from ISqlSpecifiesQuotedIdentifier.)
Public property IsReplicated Gets or sets a value that indicates whether the object is subject to replication. (Inherited from ISqlSupportsReplication.)
Public property IsTableLockOnBulkLoad Gets or sets a value that models the "table lock on bulk load" sp_tableoption option. (Inherited from ISqlTable.)
Public property IsTrackColumnsUpdatedOn true if change tracking is enabled with TRACK_COLUMNS_UPDATED ON.
Public property IsVardecimalStorageFormatOn Gets or sets a value that indicates whether the vardecimal storage is enabled for the table. (Inherited from ISql90Table.)
Public property LockEscalation Gets or sets a value that models the LOCK_ESCALATION option.
Public property Model Gets the model reference. (Inherited from IModelEntity.)
Public property Name Gets or sets the name of the element. (Inherited from IModelElement.)
Public property Owner Gets or sets the owner of this object. (Inherited from ISqlOwnedObject.)
Public property PartitionColumn Gets or sets the column on which to partition the object. (Inherited from ISql90SpecifiesStorage.)
Public property PartitionScheme Gets or sets the partition scheme that is used to store the object. (Inherited from ISql90SpecifiesStorage.)
Public property Permissions Gets the list of permissions that apply to this object. (Inherited from ISqlSecurable.)
Public property PrimarySource Gets information about the primary source for the element. (Inherited from IScriptSourcedModelElement.)
Public property ResolutionStatus Gets or sets the value of the model element resolution status. (Inherited from IModelElement.)
Public property SecondarySources Gets a list of secondary sources for the element. (Inherited from IScriptSourcedModelElement.)
Public property SourceCodePositions Gets the list of sources that define this element. (Inherited from IModelElement.)
Public property SpatialIndexes Gets the list of spatial indexes that apply to this object (Inherited from ISql100SpatialIndexedObject.)
Public property Statistics Gets the list of statistics that apply to this object. (Inherited from ISqlStatisticBound.)
Public property Synonyms Gets the list of synonyms that are associated with this target. (Inherited from ISql90SynonymTarget.)
Public property TextInRowSize Gets or sets a value that models the "text in row" sp_tableoption option. (Inherited from ISqlTable.)
Public property Triggers Gets the list of the Data Manipulation Language (DML) triggers that involve this source. (Inherited from ISqlColumnSource.)
Public property ValidationStatus Gets or sets the value of the model element validation status. (Inherited from IModelElement.)
Public property XmlIndex Gets the list of XML indexes that are associated with this object. (Inherited from ISql90XmlIndexedObject.)

Top

Methods

  Name Description
Public method AddAnnotation Adds the given annotation to this element. (Inherited from IModelAnnotationHolder.)
Public method Delete Deletes this instance from the model. (Inherited from IModelElement.)
Public method GetAnnotations() Returns a list of annotations attached to this element. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(Type) Returns a list of attached annotations of the given type. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(ModelIdentifier) Returns a list of attached annotations that have the given identifier. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(ModelIdentifier, Type) (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations<TType>() Returns all attached model annotations that implement the given annotation type and have the specified model identifier. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations<TType>(ModelIdentifier) (Inherited from IModelAnnotationHolder.)
Public method GetColumnsRelationship() Returns the IModelMultiRelationship between this IDatabaseColumnSource and the associated IDatabaseColumn instances. (Inherited from IDatabaseColumnSource.)
Public method GetColumnsRelationship() Returns an IModelMultiRelationship between this and the associated ISqlColumn. (Inherited from ISqlColumnSource.)
Public method GetComposingChildren Returns a list of composing children for this element. (Inherited from IModelElement.)
Public method GetConstraintsRelationship() Returns an IModelReverseMultiRelationship between this and the associated ISql90Constraint. (Inherited from ISql90SpecifiesTable.)
Public method GetConstraintsRelationship() Returns an IModelReverseMultiRelationship between this and the associated ISqlConstraint. (Inherited from ISqlSpecifiesTable.)
Public method GetDataCompressionOptionsRelationship Returns an IModelReverseMultiRelationship between this and the associated ISql100DataCompressionOption. (Inherited from ISql100SpecifiesDataCompressionOptions.)
Public method GetDynamicObjectForChangeTableRelationship Returns an IModelSingleRelationship between this and the associated ISqlDynamicColumnSource.
Public method GetExtendedPropertiesRelationship Returns an IModelReverseMultiRelationship between this and the associated ISqlExtendedProperty. (Inherited from ISqlExtendedPropertyHost.)
Public method GetFilegroupForTextImageRelationship Returns an IModelSingleRelationship between this and the associated ISqlFilegroup. (Inherited from ISqlTable.)
Public method GetFilegroupRelationship Returns an IModelSingleRelationship between this and the associated ISqlFilegroup. (Inherited from ISqlSpecifiesStorage.)
Public method GetFileStreamFilegroupRelationship Returns an IModelSingleRelationship between this and the associated ISql100Filegroup. (Inherited from ISql100SpecifiesFileStream.)
Public method GetFileStreamPartitionSchemeRelationship Returns an IModelSingleRelationship between this and the associated ISql100PartitionScheme. (Inherited from ISql100SpecifiesFileStream.)
Public method GetFullTextIndexRelationship Returns an IModelReverseMultiRelationship between this and the associated ISqlFullTextIndex. (Inherited from ISqlFulltextIndexedObject.)
Public method GetHierarchicalChildren Returns a list of hierarchical children for this element. (Inherited from IModelElement.)
Public method GetIndexesRelationship() Returns the IModelReverseMultiRelationship between this IDatabaseColumnSource and any associated IDatabaseIndex instances. (Inherited from IDatabaseColumnSource.)
Public method GetIndexesRelationship() Returns an IModelReverseMultiRelationship between this and the associated ISqlIndex. (Inherited from ISqlColumnSource.)
Public method GetOwnerInfo Returns information about the element owner. (Inherited from IModelElement.)
Public method GetOwnerRelationship Returns an IModelSingleRelationship between this and the associated ISqlObjectOwner. (Inherited from ISqlOwnedObject.)
Public method GetPartitionColumnRelationship Returns an IModelSingleRelationship between this and the associated ISqlColumn. (Inherited from ISql90SpecifiesStorage.)
Public method GetPartitionSchemeRelationship Returns an IModelSingleRelationship between this and the associated ISql90PartitionScheme. (Inherited from ISql90SpecifiesStorage.)
Public method GetPermissionsRelationship Returns an IModelReverseMultiRelationship between this and the associated ISqlPermissionStatement. (Inherited from ISqlSecurable.)
Public method GetProperty<TProperty> Gets the specified property. (Inherited from IModelPropertyContainer.)
Public method 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.)
Public method 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.)
Public method GetReferencedRelationshipEntries Returns a list of the relationship entries, where this element is on the left side. (Inherited from IModelElement.)
Public method 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.)
Public method GetReferencingRelationshipEntries Returns a list of the relationship entries, where this element is on the right side. (Inherited from IModelElement.)
Public method GetRelationship(ModelRelationshipClass) Returns the requested relationship by using the provided metadata. (Inherited from IModelElement.)
Public method GetRelationship<TFrom, TTo>(ModelRelationshipClass) Returns a relationship where the two related elements are of the specified types. (Inherited from IModelElement.)
Public method GetRelationshipEntrySources Returns a collection of source information about the given relationship. (Inherited from IScriptSourcedModelElement.)
Public method GetRelationships Returns a list of the relationships in this element. (Inherited from IModelElement.)
Public method GetSpatialIndexesRelationship Returns an IModelReverseMultiRelationship between this and the associated ISql100SpatialIndex. (Inherited from ISql100SpatialIndexedObject.)
Public method GetStatisticsRelationship Returns an IModelReverseMultiRelationship between this and the associated ISqlStatistic. (Inherited from ISqlStatisticBound.)
Public method GetSynonymsRelationship Returns an IModelReverseMultiRelationship between this and the associated ISql90Synonym. (Inherited from ISql90SynonymTarget.)
Public method GetTriggersRelationship Returns an IModelReverseMultiRelationship between this and the associated ISqlDmlTrigger. (Inherited from ISqlColumnSource.)
Public method GetXmlIndexRelationship Returns an IModelReverseMultiRelationship between this and the associated ISql90XmlIndex. (Inherited from ISql90XmlIndexedObject.)
Public method IsDeleted Specifies whether the object is deleted. (Inherited from IModelElement.)
Public method 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.)
Public method RemoveAnnotation Removes the specified annotation from this model element. (Inherited from IModelAnnotationHolder.)
Public method SetProperty<TProperty> Sets the specified property. (Inherited from IModelPropertyContainer.)

Top

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace