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

NameDescription
System_CAPS_pubpropertyBodyText

Gets or sets the Transact-SQL statements that define the module.

System_CAPS_pubpropertyExecutionContext

Gets or sets an IExecutionContext object that specifies the module execution context.(Inherited from IMutableUserDefinedFunctionModuleBase.)

System_CAPS_pubpropertyForReplication

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

System_CAPS_pubpropertyIsEncrypted

Gets or sets a value that indicates whether the module is encrypted.(Inherited from IMutableUserDefinedFunctionModuleBase.)

System_CAPS_pubpropertyIsQuotedIdentifierOn

Gets a Boolean value that indicates whether the quoted identifier option is on.(Inherited from IStoredProcedure.)

System_CAPS_pubpropertyIsRecompiled

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

System_CAPS_pubpropertyIsSqlClr

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

System_CAPS_pubpropertyIsSystemObject

Gets or sets a value that indicates whether this is a system object.(Inherited from IMutableDatabaseObject.)

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 IMutableFunctionModuleBase.)

System_CAPS_pubpropertyParent

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

System_CAPS_pubpropertyReturnType

Gets or sets the scalar data type of the module return value.(Inherited from IMutableCallableModule.)

System_CAPS_pubpropertySchema

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

System_CAPS_pubpropertyStartup

Gets or sets 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: