pdb_get_columns

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

Syntax

pdb_get_columns [ownername, tablename[, colname]]

Parameters

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

Examples

Example 1 –
```
pdb_get_columns
```
This command returns a list of all of the columns in all of the user tables in the current database.
Example 2 –
```
pdb_get_columns bob, authors
```
This command returns a list of all of the columns in the table authors, owned by the user “bob” in the current database.
Example 3 –
```
pdb_get_columns bob, authors, au_fname
```
This command returns information about the column au_fname in the table authors, owned by the user “bob” in the current database.

Usage

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

When pdb_get_columns is invoked with no option, it returns a result set that lists all of the columns in all of the user tables in the current database.
When pdb_get_columns is invoked with the ownername and tablename options, it returns a result set that lists all of the columns in the specified table with the specified owner in the current database.
When pdb_get_columns is invoked with the ownername, tablename, and colname options, it returns a result set with information about the specified column in the specified table with the specified owner in the current database.
The pdb_get_columns command accepts the % wildcard character in the ownername, tablename, and colname options.
The current database is either:
- The default current database, which is the primary database specified in the Replication Agent pds_database_name configuration parameter, or
- The database specified in the pdb_set_sql_database command (to which the Replication Agent instance is currently connected).
To set or change the current database, use the pdb_set_sql_database command.

Note: If the pdb_set_sql_database command has not been invoked to set or change the current database, the pdb_get_columns command returns information from the current database.
To find the name of the current database, use the pdb_get_sql_database command.
The pdb_get_columns command returns 0 rows if the specified table (with the specified owner) does not exist in the current database or if the specified column does not exist in the specified table.
The pdb_get_columns command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.