solidDB Help : solidDB reference : SQL: Database system tables and system views : System tables for data synchronization : SYS_PUBLICATION_REPLICA_STMTS
  
SYS_PUBLICATION_REPLICA_STMTS
The SYS_PUBLICATION_REPLICA_STMTS table contains the definition of the publication statements in a replica database.
The columns in the SYS_PUBLICATION_REPLICA_STMTS system table are described in the following table:
 
Column name
Description
MASTER_ID
Internal ID of the master from which the data is refreshed.
PUBL_ID
Internal ID of the publication.
STMT_NUMBER
Sequence number of the statement.
REPLICA_CATALOG
Name of the target catalog in the replica database.
REPLICA_SCHEMA
Name of the target schema in the replica database.
REPLICA_TABLE
Name of the target table in the replica database.
TABLE_ALIAS
Alias name of the target table.
REPLICA_FROM_STR
SQL FROM tables as string.
WHERE STR
SQL WHERE arguments as string.
LEVEL
Level of this SQL statement in this publication hierarchy.
Go up to
System tables for data synchronization