The SYSREMOTETYPE system view contains information about SQL Remote. The underlying system table for this view is ISYSREMOTETYPE.
| Column name | Data 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
UNIQUE Index (type_name)