Procedures
The Procedures schema collection describes the available stored procedures.
Retrieving the Stored Procedure Listing
To retrieve the Procedures schema collection, call the GetSchema method of the AzureDevOpsConnection class. Access the metadata in the DataTable object returned.
The following example outputs a list of stored procedure names:
C#
String connectionString = "AuthScheme=Basic;Organization=MyAzureDevOpsOrganization;Catalog=Project_dev;Schema=Project;PersonalAccessToken=MyPAT;"; using (AzureDevOpsConnection conn = new AzureDevOpsConnection(connectionString)) { conn.Open(); DataTable table = conn.GetSchema("Procedures"); foreach (DataRow row in table.Rows) Console.WriteLine(row["SPECIFIC_NAME"]); }
VB.NET
Dim connectionString As String = "AuthScheme=Basic;Organization=MyAzureDevOpsOrganization;Catalog=Project_dev;Schema=Project;PersonalAccessToken=MyPAT;" Using conn As New AzureDevOpsConnection(connectionString) conn.Open() Dim table As DataTable = conn.GetSchema("Procedures") For Each row As DataRow in table.Rows Console.WriteLine(row("SPECIFIC_NAME")) Next End Using
Columns Returned
The Procedures schema collection contains the following columns:
Column Name | Data Type | Description |
SPECIFIC_CATALOG | System.String | The name of the database containing the stored procedure. |
SPECIFIC_SCHEMA | System.String | The schema that contains the stored procedure. |
SPECIFIC_NAME | System.String | The name of the stored procedure containing the parameter. |
ROUTINE_CATALOG | System.String | The database containing the stored procedure. |
ROUTINE_SCHEMA | System.String | The schema containing the stored procedure. |
ROUTINE_NAME | System.String | The name of the stored procedure. |
ROUTINE_TYPE | System.String | Returns PROCEDURE for stored procedures and FUNCTION for functions. |