Returns a list of user tables in the current database at the primary data server.
pdb_get_tables [ownername, tablename]
The user name of the owner of the table specified in tablename. This option 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 option can be delimited with quote characters to specify character case.
pdb_get_tables
This command returns a list of all of the user tables in the current database.
pdb_get_columns bob, authors
This command returns information about the table authors, owned by the user “bob” in the current database.
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.
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 default current database is the primary database to which the Mirror Replication Agent instance is connected. The default current database is identified by the pds_database_name configuration parameter.
If the pdb_set_sql_database command
has not been invoked to set the current database, the pdb_get_tables command
returns results from the primary database to which the Mirror Replication Agent instance
is connected.
To set or change the current database, use the pdb_set_sql_database command.
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 Mirror Replication Agent instance is in either Admin or Replicating state.
pdb_get_columns, pdb_get_databases, pdb_get_primary_keys, pdb_get_procedure_parms, pdb_get_procedures
