Share via

  • Article

IStoredProcedure Interface

Represents a SQL Server stored procedure. 

Namespace:  Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)

Syntax

'Declaration
Public Interface IStoredProcedure _
    Inherits ICallableModule, IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject,  _
    IFunctionModuleBase, IMetadataObject
'Usage
Dim instance As IStoredProcedure

public interface IStoredProcedure : ICallableModule, 
    IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject

public interface class IStoredProcedure : ICallableModule, 
    IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject

type IStoredProcedure =  
    interface
        interface ICallableModule
        interface IUserDefinedFunctionModuleBase
        interface ISchemaOwnedObject
        interface IDatabaseObject
        interface IFunctionModuleBase
        interface IMetadataObject
    end

public interface IStoredProcedure extends ICallableModule, IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject

The IStoredProcedure type exposes the following members.

Properties

  Name Description
Public property BodyText Gets the Transact-SQL statements that define the module.
Public property ExecutionContext Gets the IExecutionContext object that specifies the module execution context. (Inherited from IUserDefinedFunctionModuleBase.)
Public property ForReplication Gets a value that indicates whether the stored procedure is available for replication.
Public property IsEncrypted Gets a value that indicates whether the module is encrypted. (Inherited from IUserDefinedFunctionModuleBase.)
Public property IsQuotedIdentifierOn Gets a Boolean value that indicates whether the quoted identifier option is on.
Public property IsRecompiled Gets a value that indicates whether the stored procedure is recompiled before execution.
Public property IsSqlClr Gets a value that indicates whether this is a CLR module.
Public property IsSystemObject Gets a value that indicates whether this is a system object. (Inherited from IDatabaseObject.)
Public property ModuleType Gets the module type. (Inherited from ICallableModule.)
Public property Name Gets the name of the metadata object. (Inherited from IMetadataObject.)
Public property Parameters Gets a collection that contains the parameters that the function or module accepts. (Inherited from IFunctionModuleBase.)
Public property Parent Gets the IDatabaseObject object that is the parent of this object. (Inherited from IDatabaseObject.)
Public property ReturnType Gets the scalar data type of the module return value. (Inherited from ICallableModule.)
Public property Schema Gets the ISchema object that owns this object. (Inherited from ISchemaOwnedObject.)
Public property Startup Gets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up.

Top

Methods

  Name Description
Public method Accept<T>(IDatabaseObjectVisitor<T>) Accepts a visit from the specified IDatabaseObjectVisitor<T> object. (Inherited from IDatabaseObject.)
Public method Accept<T>(IMetadataObjectVisitor<T>) Accepts a visit from the specified IMetadataObjectVisitor<T> object. (Inherited from IMetadataObject.)
Public method Accept<T>(ISchemaOwnedObjectVisitor<T>) Accepts a visit from the specified ISchemaOwnedObjectVisitor<T> object. (Inherited from ISchemaOwnedObject.)

Top