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: (For Oracle and Microsoft SQL Server) Results from these commands are taken from the Replication Agent System database (RASD). (For UDB) Results from these commands are taken directly from the primary database.

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.