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
	BodyText	Gets or sets the Transact-SQL statements that define the module.
	BodyText	Gets the Transact-SQL statements that define the module. (Inherited from IStoredProcedure.)
	ExecutionContext	Gets or sets an IExecutionContext object that specifies the module execution context. (Inherited from IMutableUserDefinedFunctionModuleBase.)
	ExecutionContext	Gets the IExecutionContext object that specifies the module execution context. (Inherited from IUserDefinedFunctionModuleBase.)
	ForReplication	Gets or sets a value that indicates whether the stored procedure is available for replication
	ForReplication	Gets a value that indicates whether the stored procedure is available for replication. (Inherited from IStoredProcedure.)
	IsEncrypted	Gets or sets a value that indicates whether the module is encrypted. (Inherited from IMutableUserDefinedFunctionModuleBase.)
	IsEncrypted	Gets a value that indicates whether the module is encrypted. (Inherited from IUserDefinedFunctionModuleBase.)
	IsQuotedIdentifierOn	Gets a Boolean value that indicates whether the quoted identifier option is on. (Inherited from IStoredProcedure.)
	IsRecompiled	Gets or sets a value that indicates whether the stored procedure is recompiled before execution.
	IsRecompiled	Gets a value that indicates whether the stored procedure is recompiled before execution. (Inherited from IStoredProcedure.)
	IsSqlClr	Gets or sets a value that indicates whether this is a CLR module.
	IsSqlClr	Gets a value that indicates whether this is a CLR module. (Inherited from IStoredProcedure.)
	IsSystemObject	Gets a value that indicates whether this is a system object. (Inherited from IDatabaseObject.)
	IsSystemObject	Gets or sets a value that indicates whether this is a system object. (Inherited from IMutableDatabaseObject.)
	ModuleType	Gets the module type. (Inherited from ICallableModule.)
	Name	Gets the name of the metadata object. (Inherited from IMetadataObject.)
	Parameters	Gets a collection that contains the parameters that the function or module accepts. (Inherited from IFunctionModuleBase.)
	Parameters	Gets a collection that contains the parameters that the function or module accepts. (Inherited from IMutableFunctionModuleBase.)
	Parent	Gets the IDatabaseObject object that is the parent of this object. (Inherited from IDatabaseObject.)
	ReturnType	Gets the scalar data type of the module return value. (Inherited from ICallableModule.)
	ReturnType	Gets or sets the scalar data type of the module return value. (Inherited from IMutableCallableModule.)
	Schema	Gets the ISchema object that owns this object. (Inherited from ISchemaOwnedObject.)
	Startup	Gets or sets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up.
	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
	Accept<T>(IDatabaseObjectVisitor<T>)	Accepts a visit from the specified IDatabaseObjectVisitor<T> object. (Inherited from IDatabaseObject.)
	Accept<T>(IMetadataObjectVisitor<T>)	Accepts a visit from the specified IMetadataObjectVisitor<T> object. (Inherited from IMetadataObject.)
	Accept<T>(ISchemaOwnedObjectVisitor<T>)	Accepts a visit from the specified ISchemaOwnedObjectVisitor<T> object. (Inherited from ISchemaOwnedObject.)

Top

See Also

Reference

Microsoft.SqlServer.Management.SqlParser.Metadata Namespace