IDbStoredProcedureManager.GetStoredProcedureEditStatement Method

Article
05/02/2012

Returns the ALTER PROCEDURE statement for a stored procedure.

Namespace: Microsoft.Web.Management.DatabaseManager
Assembly: Microsoft.Web.Management.DatabaseManager (in Microsoft.Web.Management.DatabaseManager.dll)

Syntax

'Declaration
Function GetStoredProcedureEditStatement ( _
    connectionString As String, _
    schema As String, _
    storedProcedureName As String _
) As Query
'Usage
Dim instance As IDbStoredProcedureManager
Dim connectionString As String
Dim schema As String
Dim storedProcedureName As String
Dim returnValue As Query

returnValue = instance.GetStoredProcedureEditStatement(connectionString, _
    schema, storedProcedureName)

Query GetStoredProcedureEditStatement(
    string connectionString,
    string schema,
    string storedProcedureName
)

Query^ GetStoredProcedureEditStatement(
    String^ connectionString, 
    String^ schema, 
    String^ storedProcedureName
)

function GetStoredProcedureEditStatement(
    connectionString : String, 
    schema : String, 
    storedProcedureName : String
) : Query

Parameters

connectionString
Type: System.String
The connection string for the database.

schema
Type: System.String
The schema name for the stored procedure.
Note If schema is empty, the default schema name will be used.

storedProcedureName
Type: System.String
The name of the stored procedure.

Return Value

Type: Microsoft.Web.Management.DatabaseManager.Query
A Query object that contains the ALTER PROCEDURE statement for a stored procedure.

Remarks

All database providers that implement the IDbStoredProcedureManager interface must also implement the GetStoredProcedureEditStatement method, which returns an ALTER PROCEDURE statement for your database provider.

Notes for Implementers

If your provider does not support editing stored procedures, you can use the following code sample to raise a not-implemented exception:

public Query GetStoredProcedureEditStatement(string connectionString, string schema, string storedProcedureName)

{

throw new NotImplementedException();

}

Note

See the ALTER PROCEDURE (Transact-SQL) topic for more information about the ALTER PROCEDURE SQL statement.

Permissions

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

Share via