Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » System Objects » Views » System views

 

SYSREMOTETYPE system view

The SYSREMOTETYPE system view contains information about SQL Remote. The underlying system table for this view is ISYSREMOTETYPE.

Column name Column type Description
type_id SMALLINT Identifies which of the message systems supported by SQL Remote is to be used to send messages to the user.
object_id UNSIGNED BIGINT The internal ID for the remote type, uniquely identifying it in the database.
type_name CHAR(128) The name of the message system supported by SQL Remote.
publisher_address LONG VARCHAR The address of the remote database publisher.
remarks LONG VARCHAR Remarks about the remote type. This value is stored in the ISYSREMARK system table.
Constraints on underlying system table

PRIMARY KEY (type_id)

FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL