Returns a list of columns in the specified table in the current database at the primary database server.
pdb_get_columns [ownername, tablename[, colname]]
The name of the owner of the table specified in the tablename parameter. This parameter can be delimited with quote characters to specify character case.
The name of the table in the current database for which information is returned. This parameter can be delimited with quote characters to specify character case.
The name of the column for which information is returned. This parameter can be delimited with quote characters to specify character case.
When pdb_get_columns is invoked, it returns a result set that lists the column (or columns) in the specified table owned by the specified owner in the current database.
When pdb_get_columns is invoked with no options, it returns a result set that lists all the columns in all the tables owned by all the owners in the current database.
The pdb_get_columns command accepts the % character as a wild card in the ownername, tablename, and colname options.
The default current database is the primary database to which the Replication Agent instance is connected (as specified by the Replication Agent pds_database_name configuration parameter).
If a current database is not set with the pdb_set_sql_database command,
the pdb_get_columns command
returns results from the primary database to which the Replication Agent instance
is connected.
To set or change the current database, use the pdb_set_sql_database command.
To find out 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 either Admin or Replicating state.
pdb_get_databases, pdb_get_primary_keys, pdb_get_procedure_parms, pdb_get_procedures, pdb_get_tables
