StoredProcedure Constructor (Database, String, String)

Initializes a new instance of the StoredProcedure class on the specified database and with the specified name and schema.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub New ( _
    database As Database, _
    name As String, _
    schema As String _
)
'Usage
Dim database As Database 
Dim name As String 
Dim schema As String 

Dim instance As New StoredProcedure(database, _
    name, schema)

public StoredProcedure(
    Database database,
    string name,
    string schema
)

public:
StoredProcedure(
    Database^ database, 
    String^ name, 
    String^ schema
)

new : 
        database:Database * 
        name:string * 
        schema:string -> StoredProcedure

public function StoredProcedure(
    database : Database, 
    name : String, 
    schema : String
)

Parameters

• database
  Type: Microsoft.SqlServer.Management.Smo.Database
  A Database object value that specifies the database in which to create the stored procedure.

• name
  Type: System.String
  A String value that specifies the name of the stored procedure.

• schema
  Type: System.String
  A String value that specifies the schema of the database in which to create the stored procedure.

Examples

Creating, Altering, and Removing Stored Procedures

See Also

Reference

StoredProcedure Class

StoredProcedure Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE PROCEDURE (Transact-SQL)