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.|
PRIMARY KEY (type_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|