Export (0) Print
Expand All

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)

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

The IMutableStoredProcedure type exposes the following members.

  NameDescription
Public propertyBodyTextGets or sets the Transact-SQL statements that define the module.
Public propertyExecutionContextGets or sets an IExecutionContext object that specifies the module execution context. (Inherited from IMutableUserDefinedFunctionModuleBase.)
Public propertyForReplicationGets or sets a value that indicates whether the stored procedure is available for replication
Public propertyIsEncryptedGets or sets a value that indicates whether the module is encrypted. (Inherited from IMutableUserDefinedFunctionModuleBase.)
Public propertyIsQuotedIdentifierOnGets a Boolean value that indicates whether the quoted identifier option is on. (Inherited from IStoredProcedure.)
Public propertyIsRecompiledGets or sets a value that indicates whether the stored procedure is recompiled before execution.
Public propertyIsSqlClrGets or sets a value that indicates whether this is a CLR module.
Public propertyIsSystemObjectGets or sets a value that indicates whether this is a system object. (Inherited from IMutableDatabaseObject.)
Public propertyModuleTypeGets the module type. (Inherited from ICallableModule.)
Public propertyNameGets the name of the metadata object. (Inherited from IMetadataObject.)
Public propertyParametersGets a collection that contains the parameters that the function or module accepts. (Inherited from IMutableFunctionModuleBase.)
Public propertyParentGets the IDatabaseObject object that is the parent of this object. (Inherited from IDatabaseObject.)
Public propertyReturnTypeGets or sets the scalar data type of the module return value. (Inherited from IMutableCallableModule.)
Public propertySchemaGets the ISchema object that owns this object. (Inherited from ISchemaOwnedObject.)
Public propertyStartupGets or sets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up.
Top

  NameDescription
Public methodAccept<T>(IDatabaseObjectVisitor<T>)Accepts a visit from the specified IDatabaseObjectVisitor<T> object. (Inherited from IDatabaseObject.)
Public methodAccept<T>(IMetadataObjectVisitor<T>)Accepts a visit from the specified IMetadataObjectVisitor<T> object. (Inherited from IMetadataObject.)
Public methodAccept<T>(ISchemaOwnedObjectVisitor<T>)Accepts a visit from the specified ISchemaOwnedObjectVisitor<T> object. (Inherited from ISchemaOwnedObject.)
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft