solidDB Help : solidDB reference : SQL: Database system tables and system views : System tables for data synchronization : SYS_PUBLICATION_STMTS
  
SYS_PUBLICATION_STMTS
The SYS_PUBLICATION_STMTS table contains the publication statements in the master database.
The columns in the SYS_PUBLICATION_STMTS system table are described in the following table:
 
Column name
Description
PUBL_ID
Internal ID of the publication.
MASTER_SCHEMA
Name of the publication schema in the master database.
MASTER_TABLE
Name of the table in the master database.
REPLICA_SCHEMA
Name of the schema in the replica database.
REPLICA_TABLE
Name of the table in the replica database.
TABLE_ALIAS
The alias name of the target table.
MASTER_SELECT_STR
SQL SELECT INTO columns as string.
REPLICA_SELECT_STR
SQL SELECT INTO columns as string.
MASTER_FROM_STR
SQL SELECT FROM tables as string.
REPLICA_FROM_STR
SQL SELECT FROM tables as string.
WHERE_STR
SQL WHERE arguments as a string.
DELETEFLAG_STR
For internal use.
LEVEL
Level of this SQL statement in the publication hierarchy.
Go up to
System tables for data synchronization