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.
	ExecutionContext	Gets or sets an IExecutionContext object that specifies the module execution context. (Inherited from IMutableUserDefinedFunctionModuleBase.)
	ForReplication	Gets or sets a value that indicates whether the stored procedure is available for replication
	IsEncrypted	Gets or sets a value that indicates whether the module is encrypted. (Inherited from IMutableUserDefinedFunctionModuleBase.)
	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.
	IsSqlClr	Gets or sets a value that indicates whether this is a CLR module.
	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 IMutableFunctionModuleBase.)
	Parent	Gets the IDatabaseObject object that is the parent of this object. (Inherited from IDatabaseObject.)
	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.

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