User's Manual

Chapter 16. System Objects for Adaptive Server Enterprise
Columns
Column Description
publication_name The name of the publication
sr_remoteoptions view
Function Lists the SQL Remote message link parameters and their values, as stored in
the remoteoption and remoteoptiontype system tables, in more readable
form.
Columns
Column Description
type_name The message link type.
"option" The option name.
setting The option value.
sr_remotetables view
Function Lists the tables marked for SQL Remote replication, as stored in the
remotetable system table, in more readable form.
This table exists only in Adaptive Server Enterprise.
Columns
Column Description
table_name The name of the table.
resolve_name The name of the stored procedure to be executed in
the case of conflicts.
old_row_name The table that holds the old row name.
remote_row_name The table that holds the remote row name.
sr_remotetypes view
Function Lists the message types, as stored in the remotetype system table.
Columns
347