ISql90Procedure Interface

Models a stored procedure.

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

Syntax

'Declaration
Public Interface ISql90Procedure _
    Inherits ISqlProcedure, IDatabaseProcedure, ISqlOwnedObject, ISqlSecurable,  _
    ISqlExtendedPropertyHost, ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISql90Subroutine,  _
    ISqlSubroutine, IModelNamed, ISql90SpecifiesExecutionContext, ISql90ClrMethodDefined, ISql90ClrClassDefined,  _
    ISql90SynonymTarget, ISql90Signable, ISqlModelElement, IScriptSourcedModelElement, IModelElement,  _
    IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

public interface ISql90Procedure : ISqlProcedure, 
    IDatabaseProcedure, ISqlOwnedObject, ISqlSecurable, ISqlExtendedPropertyHost, ISqlSpecifiesAnsiNulls, 
    ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISql90Subroutine, ISqlSubroutine, IModelNamed, 
    ISql90SpecifiesExecutionContext, ISql90ClrMethodDefined, ISql90ClrClassDefined, ISql90SynonymTarget, ISql90Signable, 
    ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, 
    IModelAnnotationHolder

public interface class ISql90Procedure : ISqlProcedure, 
    IDatabaseProcedure, ISqlOwnedObject, ISqlSecurable, ISqlExtendedPropertyHost, ISqlSpecifiesAnsiNulls, 
    ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISql90Subroutine, ISqlSubroutine, IModelNamed, 
    ISql90SpecifiesExecutionContext, ISql90ClrMethodDefined, ISql90ClrClassDefined, ISql90SynonymTarget, ISql90Signable, 
    ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, 
    IModelAnnotationHolder

type ISql90Procedure =  
    interface
        interface ISqlProcedure
        interface IDatabaseProcedure
        interface ISqlOwnedObject
        interface ISqlSecurable
        interface ISqlExtendedPropertyHost
        interface ISqlSpecifiesAnsiNulls
        interface ISqlSpecifiesQuotedIdentifier
        interface ISqlSupportsReplication
        interface ISql90Subroutine
        interface ISqlSubroutine
        interface IModelNamed
        interface ISql90SpecifiesExecutionContext
        interface ISql90ClrMethodDefined
        interface ISql90ClrClassDefined
        interface ISql90SynonymTarget
        interface ISql90Signable
        interface ISqlModelElement
        interface IScriptSourcedModelElement
        interface IModelElement
        interface IModelPropertyContainer
        interface IModelEntity
        interface IModelAnnotationHolder
    end

public interface ISql90Procedure extends ISqlProcedure, IDatabaseProcedure, ISqlOwnedObject, ISqlSecurable, ISqlExtendedPropertyHost, ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISqlSupportsReplication, ISql90Subroutine, ISqlSubroutine, IModelNamed, ISql90SpecifiesExecutionContext, ISql90ClrMethodDefined, ISql90ClrClassDefined, ISql90SynonymTarget, ISql90Signable, ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

The ISql90Procedure type exposes the following members.

Properties

	Name	Description
	Assembly	Gets or sets the assembly that defines this SQL Server SQL CLR class. (Inherited from ISql90ClrClassDefined.)
	BodyDependencies	Gets the collection of elements that are referenced by the body of the procedure. (Inherited from IDatabaseProcedure.)
	BodyScript	Gets or sets the body of the procedure. (Inherited from ISqlProcedure.)
	ClassName	Gets or sets the name of the SQL Server SQL CLR class. (Inherited from ISql90ClrClassDefined.)
	DynamicObjects	Gets the list of temporary column sources that are created in the procedure body. (Inherited from ISqlProcedure.)
	ElementClass	Gets the metadata class for an element. (Inherited from IModelElement.)
	ExtendedProperties	Gets the list of extended properties for this object. (Inherited from ISqlExtendedPropertyHost.)
	IsAnsiNullsOn	Gets or sets a value that indicates whether the ANSI NULLS setting is ON for this object. (Inherited from ISqlSpecifiesAnsiNulls.)
	IsCaller	Gets or sets a value that indicates whether the object is executed as the caller. (Inherited from ISql90SpecifiesExecutionContext.)
	IsEncrypted	Gets or sets a value that indicates whether the subroutine is encrypted. (Inherited from ISqlSubroutine.)
	IsForReplication	Gets or sets a value that models the FOR REPLICATION option. (Inherited from ISqlProcedure.)
	IsOwner	Gets or sets a value that indicates whether the object is executed as its owner. (Inherited from ISql90SpecifiesExecutionContext.)
	IsQuotedIdentifierOn	Gets or sets a value that indicates whether the QUOTED IDENTIFIER setting is ON for this object. (Inherited from ISqlSpecifiesQuotedIdentifier.)
	IsRecompiled	Gets or sets a value that models the RECOMPILE option. (Inherited from ISqlProcedure.)
	IsReplicated	Gets or sets a value that indicates whether the object is subject to replication. (Inherited from ISqlSupportsReplication.)
	IsSelf	Gets or sets a value that indicates whether the object is executed as its creator. (Inherited from ISql90SpecifiesExecutionContext.)
	Login	Gets or sets the login as which to execute. (Inherited from ISql90SpecifiesExecutionContext.)
	MethodName	Gets or sets the name of the SQL Server SQL CLR method. (Inherited from ISql90ClrMethodDefined.)
	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.)
	Parameters	Gets the list of parameters to the subroutine. (Inherited from ISqlSubroutine.)
	ParentProc	Gets or sets the parent procedure for a numbered stored procedure. (Inherited from ISqlProcedure.)
	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.)
	Signatures	Gets a list of the signatures that apply to this signable object. (Inherited from ISql90Signable.)
	SourceCodePositions	Gets the list of sources that define this element. (Inherited from IModelElement.)
	Synonyms	Gets the list of synonyms that are associated with this target. (Inherited from ISql90SynonymTarget.)
	User	Gets or sets the user as which to execute. (Inherited from ISql90SpecifiesExecutionContext.)
	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.)
	GetAssemblyRelationship	Returns an IModelSingleRelationship between this and the associated ISql90Assembly. (Inherited from ISql90ClrClassDefined.)
	GetBodyDependenciesRelationship	Gets the IModelMultiRelationship between this IDatabaseProcedure and any IModelElement nodes that are referenced by the stored procedure body. (Inherited from IDatabaseProcedure.)
	GetComposingChildren	Returns a list of composing children for this element. (Inherited from IModelElement.)
	GetDynamicObjectsRelationship	Returns an IModelMultiRelationship between this and the associated ISqlDynamicColumnSource. (Inherited from ISqlProcedure.)
	GetExtendedPropertiesRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlExtendedProperty. (Inherited from ISqlExtendedPropertyHost.)
	GetHierarchicalChildren	Returns a list of hierarchical children for this element. (Inherited from IModelElement.)
	GetLoginRelationship	Returns an IModelSingleRelationship between this and the associated ISql90Login. (Inherited from ISql90SpecifiesExecutionContext.)
	GetOwnerInfo	Returns information about the element owner. (Inherited from IModelElement.)
	GetOwnerRelationship	Returns an IModelSingleRelationship between this and the associated ISqlObjectOwner. (Inherited from ISqlOwnedObject.)
	GetParametersRelationship	Returns an IModelMultiRelationship between this and the associated ISqlSubroutineParameter. (Inherited from ISqlSubroutine.)
	GetParentProcRelationship	Returns an IModelSingleRelationship between this and the associated ISqlProcedure. (Inherited from ISqlProcedure.)
	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.)
	GetSignaturesRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISql90Signature. (Inherited from ISql90Signable.)
	GetSynonymsRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISql90Synonym. (Inherited from ISql90SynonymTarget.)
	GetUserRelationship	Returns an IModelSingleRelationship between this and the associated ISql90User. (Inherited from ISql90SpecifiesExecutionContext.)
	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