pdb_get_primary

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

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.

Note: Results from these commands are from the Replication Agent System database (RASD).

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 the default current database, which is the primary database specified in the Replication Agent pds_database_name configuration parameter.
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.