pdb_get_tables

Description

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

Syntax

pdb_get_tables [ownername, tablename]

Parameters

Examples

Example 1

pdb_get_tables

This command returns a list of all of the user tables in the current database.

Example 2

pdb_get_tables bob, authors

This command returns information about the table authors, owned by the user “bob” in the current database.

Usage

• When pdb_get_tables is invoked with no option, it returns a result set that lists all of the user tables in the current database.

  System tables may or may not be returned by some primary data servers when the pdb_get_tables command is invoked.

• When pdb_get_tables is invoked with the ownername and tablename options, it returns a result set with information about the specified table with the specified owner in the current database.

• The pdb_get_tables command accepts the % wildcard character in the both the ownername and tablename 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. (This is not valid for Oracle.)

• To set or change the current database, use the pdb_set_sql_database command.

  In Oracle, you cannot change the current database.

• To find the name of the current database, use the pdb_get_sql_database command.

• The pdb_get_tables command returns 0 rows if the specified table (with the specified owner) does not exist in the current database.

• The pdb_get_tables command is valid when the Replication Agent instance is in either Admin or Replicating state.

See also