Returns a list of primary key columns in a specified table
in the current database at the primary data server.
Syntax
pdb_get_primary_keys ownername, tablename
Parameters
- ownername – The user name of the owner of the table specified
in tablename. This option can be delimited
with quote characters to specify character case.
- tablename – The name of the table in the current database for
which primary key column information is returned. This option can
be delimited with quote characters to specify character case.
Usage
Note: (For Oracle and Microsoft SQL Server) Results from these
commands are from the Replication Agent System database (RASD). (For UDB) Results from these commands are directly from the primary
database.
When pdb_get_primary_keys is
invoked, it returns a result set that lists all of the columns that
are defined as primary keys in the specified table with the specified
owner in the current database.
The pdb_get_primary_keys command
accepts the % wildcard character in the ownername option,
but not in the tablename option.
-
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.
Note:
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_primary_keys command
returns 0 rows if the specified table with the specified owner does
not exist in the current database.
The pdb_get_primary_keys command
is valid when the Replication Agent instance is in the Admin, Replicating,
or Replication Down state.