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 |