Share via

  • Article

IMutableStoredProcedure Interface

Represents a mutable 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 IMutableStoredProcedure _
    Inherits IStoredProcedure, IMutableCallableModule, ICallableModule, IMutableUserDefinedFunctionModuleBase,  _
    IUserDefinedFunctionModuleBase, IMutableSchemaOwnedObject, ISchemaOwnedObject, IMutableDatabaseObject, IDatabaseObject,  _
    IMutableFunctionModuleBase, IFunctionModuleBase, IMutableMetadataObject, IMetadataObject
'Usage
Dim instance As IMutableStoredProcedure

public interface IMutableStoredProcedure : IStoredProcedure, 
    IMutableCallableModule, ICallableModule, IMutableUserDefinedFunctionModuleBase, IUserDefinedFunctionModuleBase, IMutableSchemaOwnedObject, 
    ISchemaOwnedObject, IMutableDatabaseObject, IDatabaseObject, IMutableFunctionModuleBase, IFunctionModuleBase, 
    IMutableMetadataObject, IMetadataObject

public interface class IMutableStoredProcedure : IStoredProcedure, 
    IMutableCallableModule, ICallableModule, IMutableUserDefinedFunctionModuleBase, IUserDefinedFunctionModuleBase, IMutableSchemaOwnedObject, 
    ISchemaOwnedObject, IMutableDatabaseObject, IDatabaseObject, IMutableFunctionModuleBase, IFunctionModuleBase, 
    IMutableMetadataObject, IMetadataObject

type IMutableStoredProcedure =  
    interface
        interface IStoredProcedure
        interface IMutableCallableModule
        interface ICallableModule
        interface IMutableUserDefinedFunctionModuleBase
        interface IUserDefinedFunctionModuleBase
        interface IMutableSchemaOwnedObject
        interface ISchemaOwnedObject
        interface IMutableDatabaseObject
        interface IDatabaseObject
        interface IMutableFunctionModuleBase
        interface IFunctionModuleBase
        interface IMutableMetadataObject
        interface IMetadataObject
    end

public interface IMutableStoredProcedure extends IStoredProcedure, IMutableCallableModule, ICallableModule, IMutableUserDefinedFunctionModuleBase, IUserDefinedFunctionModuleBase, IMutableSchemaOwnedObject, ISchemaOwnedObject, IMutableDatabaseObject, IDatabaseObject, IMutableFunctionModuleBase, IFunctionModuleBase, IMutableMetadataObject, IMetadataObject

The IMutableStoredProcedure type exposes the following members.

Properties

  Name Description
Public property BodyText Gets or sets the Transact-SQL statements that define the module.
Public property BodyText Gets the Transact-SQL statements that define the module. (Inherited from IStoredProcedure.)
Public property ExecutionContext Gets or sets an IExecutionContext object that specifies the module execution context. (Inherited from IMutableUserDefinedFunctionModuleBase.)
Public property ExecutionContext Gets the IExecutionContext object that specifies the module execution context. (Inherited from IUserDefinedFunctionModuleBase.)
Public property ForReplication Gets or sets a value that indicates whether the stored procedure is available for replication
Public property ForReplication Gets a value that indicates whether the stored procedure is available for replication. (Inherited from IStoredProcedure.)
Public property IsEncrypted Gets or sets a value that indicates whether the module is encrypted. (Inherited from IMutableUserDefinedFunctionModuleBase.)
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. (Inherited from IStoredProcedure.)
Public property IsRecompiled Gets or sets a value that indicates whether the stored procedure is recompiled before execution.
Public property IsRecompiled Gets a value that indicates whether the stored procedure is recompiled before execution. (Inherited from IStoredProcedure.)
Public property IsSqlClr Gets or sets a value that indicates whether this is a CLR module.
Public property IsSqlClr Gets a value that indicates whether this is a CLR module. (Inherited from IStoredProcedure.)
Public property IsSystemObject Gets a value that indicates whether this is a system object. (Inherited from IDatabaseObject.)
Public property IsSystemObject Gets or sets a value that indicates whether this is a system object. (Inherited from IMutableDatabaseObject.)
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 Parameters Gets a collection that contains the parameters that the function or module accepts. (Inherited from IMutableFunctionModuleBase.)
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 ReturnType Gets or sets the scalar data type of the module return value. (Inherited from IMutableCallableModule.)
Public property Schema Gets the ISchema object that owns this object. (Inherited from ISchemaOwnedObject.)
Public property Startup Gets or sets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up.
Public property Startup Gets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up. (Inherited from IStoredProcedure.)

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