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();
}
Note
See the DROP PROCEDURE (Transact-SQL) topic for more information about the DROP 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.