ISqlTable Interface

Models a table.

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

Syntax

'Declaration
Public Interface ISqlTable _
    Inherits IDatabaseTable, IModelNamed, ISqlOwnedObject, ISqlExtendedPropertyHost,  _
    ISqlSecurable, ISqlColumnSource, IDatabaseColumnSource, ISqlSpecifiesStorage, ISqlSpecifiesTable,  _
    ISqlStatisticBound, ISqlFulltextIndexedObject, ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication,  _
    ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity,  _
    IModelAnnotationHolder

public interface ISqlTable : IDatabaseTable, 
    IModelNamed, ISqlOwnedObject, ISqlExtendedPropertyHost, ISqlSecurable, ISqlColumnSource, 
    IDatabaseColumnSource, ISqlSpecifiesStorage, ISqlSpecifiesTable, ISqlStatisticBound, ISqlFulltextIndexedObject, 
    ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISqlModelElement, IScriptSourcedModelElement, 
    IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

public interface class ISqlTable : IDatabaseTable, 
    IModelNamed, ISqlOwnedObject, ISqlExtendedPropertyHost, ISqlSecurable, ISqlColumnSource, 
    IDatabaseColumnSource, ISqlSpecifiesStorage, ISqlSpecifiesTable, ISqlStatisticBound, ISqlFulltextIndexedObject, 
    ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISqlModelElement, IScriptSourcedModelElement, 
    IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

type ISqlTable =  
    interface
        interface IDatabaseTable
        interface IModelNamed
        interface ISqlOwnedObject
        interface ISqlExtendedPropertyHost
        interface ISqlSecurable
        interface ISqlColumnSource
        interface IDatabaseColumnSource
        interface ISqlSpecifiesStorage
        interface ISqlSpecifiesTable
        interface ISqlStatisticBound
        interface ISqlFulltextIndexedObject
        interface ISqlSpecifiesAnsiNulls
        interface ISqlSpecifiesQuotedIdentifier
        interface ISqlSupportsReplication
        interface ISqlModelElement
        interface IScriptSourcedModelElement
        interface IModelElement
        interface IModelPropertyContainer
        interface IModelEntity
        interface IModelAnnotationHolder
    end

public interface ISqlTable extends IDatabaseTable, IModelNamed, ISqlOwnedObject, ISqlExtendedPropertyHost, ISqlSecurable, ISqlColumnSource, IDatabaseColumnSource, ISqlSpecifiesStorage, ISqlSpecifiesTable, ISqlStatisticBound, ISqlFulltextIndexedObject, ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

The ISqlTable type exposes the following members.

Properties

	Name	Description
	Columns	Gets the columns for this IDatabaseColumnSource. (Inherited from IDatabaseColumnSource.)
	Columns	Gets the list of the columns that are provided by this source. (Inherited from ISqlColumnSource.)
	Constraints	Gets the list of constraints that apply to the object. (Inherited from ISqlSpecifiesTable.)
	ElementClass	Gets the metadata class for an element. (Inherited from IModelElement.)
	ExtendedProperties	Gets the list of extended properties for this object. (Inherited from ISqlExtendedPropertyHost.)
	Filegroup	Gets or sets the filegroup on which the object is stored. (Inherited from ISqlSpecifiesStorage.)
	FilegroupForTextImage	Gets or sets a value that models the TEXTIMAGE_ON option.
	FullTextIndex	Gets the list of full-text indexes that apply to this object. (Inherited from ISqlFulltextIndexedObject.)
	Indexes	Gets the indexes that apply to this IDatabaseColumnSource. (Inherited from IDatabaseColumnSource.)
	Indexes	Gets the list of the indexes that involve this source. (Inherited from ISqlColumnSource.)
	IsAnsiNullsOn	Gets or sets a value that indicates whether the ANSI NULLS setting is ON for this object. (Inherited from ISqlSpecifiesAnsiNulls.)
	IsQuotedIdentifierOn	Gets or sets a value that indicates whether the QUOTED IDENTIFIER setting is ON for this object. (Inherited from ISqlSpecifiesQuotedIdentifier.)
	IsReplicated	Gets or sets a value that indicates whether the object is subject to replication. (Inherited from ISqlSupportsReplication.)
	IsTableLockOnBulkLoad	Gets or sets a value that models the "table lock on bulk load" sp_tableoption option.
	Model	Gets the model reference. (Inherited from IModelEntity.)
	Name	Gets or sets the name of the element. (Inherited from IModelElement.)
	Owner	Gets or sets the owner of this object. (Inherited from ISqlOwnedObject.)
	Permissions	Gets the list of permissions that apply to this object. (Inherited from ISqlSecurable.)
	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.)
	Statistics	Gets the list of statistics that apply to this object. (Inherited from ISqlStatisticBound.)
	TextInRowSize	Gets or sets a value that models the "text in row" sp_tableoption option.
	Triggers	Gets the list of the Data Manipulation Language (DML) triggers that involve this source. (Inherited from ISqlColumnSource.)
	ValidationStatus	Gets or sets the value of the model element validation status. (Inherited from IModelElement.)

Top

Methods

	Name	Description
	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.)
	GetColumnsRelationship()	Returns the IModelMultiRelationship between this IDatabaseColumnSource and the associated IDatabaseColumn instances. (Inherited from IDatabaseColumnSource.)
	GetColumnsRelationship()	Returns an IModelMultiRelationship between this and the associated ISqlColumn. (Inherited from ISqlColumnSource.)
	GetComposingChildren	Returns a list of composing children for this element. (Inherited from IModelElement.)
	GetConstraintsRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlConstraint. (Inherited from ISqlSpecifiesTable.)
	GetExtendedPropertiesRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlExtendedProperty. (Inherited from ISqlExtendedPropertyHost.)
	GetFilegroupForTextImageRelationship	Returns an IModelSingleRelationship between this and the associated ISqlFilegroup.
	GetFilegroupRelationship	Returns an IModelSingleRelationship between this and the associated ISqlFilegroup. (Inherited from ISqlSpecifiesStorage.)
	GetFullTextIndexRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlFullTextIndex. (Inherited from ISqlFulltextIndexedObject.)
	GetHierarchicalChildren	Returns a list of hierarchical children for this element. (Inherited from IModelElement.)
	GetIndexesRelationship()	Returns the IModelReverseMultiRelationship between this IDatabaseColumnSource and any associated IDatabaseIndex instances. (Inherited from IDatabaseColumnSource.)
	GetIndexesRelationship()	Returns an IModelReverseMultiRelationship between this and the associated ISqlIndex. (Inherited from ISqlColumnSource.)
	GetOwnerInfo	Returns information about the element owner. (Inherited from IModelElement.)
	GetOwnerRelationship	Returns an IModelSingleRelationship between this and the associated ISqlObjectOwner. (Inherited from ISqlOwnedObject.)
	GetPermissionsRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlPermissionStatement. (Inherited from ISqlSecurable.)
	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.)
	GetStatisticsRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlStatistic. (Inherited from ISqlStatisticBound.)
	GetTriggersRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlDmlTrigger. (Inherited from ISqlColumnSource.)
	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

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace