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

NameDescription
System_CAPS_pubpropertyBodyText

Gets the Transact-SQL statements that define the module.

System_CAPS_pubpropertyExecutionContext

Gets the IExecutionContext object that specifies the module execution context.(Inherited from IUserDefinedFunctionModuleBase.)

System_CAPS_pubpropertyForReplication

Gets a value that indicates whether the stored procedure is available for replication.

System_CAPS_pubpropertyIsEncrypted

Gets a value that indicates whether the module is encrypted.(Inherited from IUserDefinedFunctionModuleBase.)

System_CAPS_pubpropertyIsQuotedIdentifierOn

Gets a Boolean value that indicates whether the quoted identifier option is on.

System_CAPS_pubpropertyIsRecompiled

Gets a value that indicates whether the stored procedure is recompiled before execution.

System_CAPS_pubpropertyIsSqlClr

Gets a value that indicates whether this is a CLR module.

System_CAPS_pubpropertyIsSystemObject

Gets a value that indicates whether this is a system object.(Inherited from IDatabaseObject.)

System_CAPS_pubpropertyModuleType

Gets the module type.(Inherited from ICallableModule.)

System_CAPS_pubpropertyName

Gets the name of the metadata object.(Inherited from IMetadataObject.)

System_CAPS_pubpropertyParameters

Gets a collection that contains the parameters that the function or module accepts.(Inherited from IFunctionModuleBase.)

System_CAPS_pubpropertyParent

Gets the IDatabaseObject object that is the parent of this object.(Inherited from IDatabaseObject.)

System_CAPS_pubpropertyReturnType

Gets the scalar data type of the module return value.(Inherited from ICallableModule.)

System_CAPS_pubpropertySchema

Gets the ISchema object that owns this object.(Inherited from ISchemaOwnedObject.)

System_CAPS_pubpropertyStartup

Gets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up.

NameDescription
System_CAPS_pubmethodAccept<T>(IDatabaseObjectVisitor<T>)

Accepts a visit from the specified IDatabaseObjectVisitor<T> object.(Inherited from IDatabaseObject.)

System_CAPS_pubmethodAccept<T>(IMetadataObjectVisitor<T>)

Accepts a visit from the specified IMetadataObjectVisitor<T> object.(Inherited from IMetadataObject.)

System_CAPS_pubmethodAccept<T>(ISchemaOwnedObjectVisitor<T>)

Accepts a visit from the specified ISchemaOwnedObjectVisitor<T> object.(Inherited from ISchemaOwnedObject.)

Return to top
Show: