Export (0) Print
Expand All

IStoredProcedure Interface

Represents a SQL Server stored procedure. 

Namespace:  Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)

public interface IStoredProcedure : ICallableModule, 
	IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject

The IStoredProcedure type exposes the following members.

Public propertyBodyTextGets the Transact-SQL statements that define the module.
Public propertyExecutionContextGets the IExecutionContext object that specifies the module execution context. (Inherited from IUserDefinedFunctionModuleBase.)
Public propertyForReplicationGets a value that indicates whether the stored procedure is available for replication.
Public propertyIsEncryptedGets a value that indicates whether the module is encrypted. (Inherited from IUserDefinedFunctionModuleBase.)
Public propertyIsQuotedIdentifierOnGets a Boolean value that indicates whether the quoted identifier option is on.
Public propertyIsRecompiledGets a value that indicates whether the stored procedure is recompiled before execution.
Public propertyIsSqlClrGets a value that indicates whether this is a CLR module.
Public propertyIsSystemObjectGets a value that indicates whether this is a system object. (Inherited from IDatabaseObject.)
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 IFunctionModuleBase.)
Public propertyParentGets the IDatabaseObject object that is the parent of this object. (Inherited from IDatabaseObject.)
Public propertyReturnTypeGets the scalar data type of the module return value. (Inherited from ICallableModule.)
Public propertySchemaGets the ISchema object that owns this object. (Inherited from ISchemaOwnedObject.)
Public propertyStartupGets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up.

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.)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft