|
The SYSREMOTETYPE system view contains information about SQL Remote. The underlying system table for this view is ISYSREMOTETYPE.
| Column name | Column type | Column constraint |
|---|---|---|
| type_id | SMALLINT | NOT NULL |
| object_id | UNSIGNED BIGINT | NOT NULL |
| type_name | CHAR(128) | NOT NULL |
| publisher_address | LONG VARCHAR | NOT NULL |
| remarks | LONG VARCHAR |
type_id Identifies which of the message systems supported by SQL Remote is to be used to send messages to the user.
object_id The internal ID for the remote type, uniquely identifying it in the database.
type_name The name of the message system supported by SQL Remote.
publisher_address The address of the remote database publisher.
remarks 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 (type_name)