IDbStoredProcedureManager.DropProcedure Method

Removes a stored procedure from a database.

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

Syntax

'Declaration
Sub DropProcedure ( _
    connectionString As String, _
    schema As String, _
    procedureName As String _
)
'Usage
Dim instance As IDbStoredProcedureManager
Dim connectionString As String
Dim schema As String
Dim procedureName As String

instance.DropProcedure(connectionString, _
    schema, procedureName)

void DropProcedure(
    string connectionString,
    string schema,
    string procedureName
)

void DropProcedure(
    String^ connectionString, 
    String^ schema, 
    String^ procedureName
)

function DropProcedure(
    connectionString : String, 
    schema : String, 
    procedureName : String
)

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.

• procedureName
  Type: System.String
  The name of the stored procedure.

Remarks

All database providers that implement the IDbStoredProcedureManager interface must also implement the DropProcedure method, which the database manager will use to remove stored procedures from a table in a database.

Notes for Implementers

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

public void DropProcedure(string connectionString, string schema, string procedureName)

{

   throw new NotImplementedException();

}

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.

See Also

Reference

IDbStoredProcedureManager Interface

Microsoft.Web.Management.DatabaseManager Namespace