.png)
IMutableStoredProcedure Interface
SQL Server 2012
Represents a mutable SQL Server stored procedure.
Namespace: Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly: Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)
public interface IMutableStoredProcedure : IStoredProcedure, IMutableCallableModule, ICallableModule, IMutableUserDefinedFunctionModuleBase, IUserDefinedFunctionModuleBase, IMutableSchemaOwnedObject, ISchemaOwnedObject, IMutableDatabaseObject, IDatabaseObject, IMutableFunctionModuleBase, IFunctionModuleBase, IMutableMetadataObject, IMetadataObject
The IMutableStoredProcedure type exposes the following members.
| 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. |
| 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.) |
