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 | |
|---|---|---|
.gif "Public property") |
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 | |
|---|---|---|
.gif "Public method") |
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