The SYSREMOTETYPE system view contains information about SQL Remote. The underlying system table for this view is ISYSREMOTETYPE.
|Column name||Column type||Column constraint|
|object_id||UNSIGNED BIGINT||NOT NULL|
|publisher_address||LONG VARCHAR||NOT NULL|
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