pdb_get_procedures

Returns a list of procedures in the current database at the primary data server.

Syntax

pdb_get_procedures [ownername, procname]

ownername – The user name of the owner of the procedure specified in procname. This option can be delimited with quote characters to specify character case.
procname – The name of the procedure in the current database for which information is returned. This option can be delimited with quote characters to specify character case.

Example 1 –
```
pdb_get_procedures
```
This command returns a list of all of the procedures in the current database.
Example 2 –
```
pdb_get_procedures bob, sp_foo
```
This command returns information about the procedure named sp_foo, owned by the user “bob” in the current database.

Note: Results from these commands are from the Replication Agent System database (RASD).

When pdb_get_procedures is invoked with no option, it returns a result set that lists all of the procedures in the current database.
When pdb_get_procedures is invoked with the ownername and procname options, it returns a result set with information about the specified procedure with the specified owner in the current database.
The pdb_get_procedures command accepts the % wildcard character in both the ownername and procname options.
The current database is the default current database, which is the primary database specified in the Replication Agent pds_database_name configuration parameter.
To find the name of the current database, use the pdb_get_sql_database command.
The pdb_get_procedures command returns 0 rows if the specified procedure (with the specified owner) does not exist in the current database.
The pdb_get_procedures command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.