Contents Index SYSREMOTEOPTIONTYPE system table SYSREMOTEUSER system table

ASA SQL Reference
  System Tables

SYSREMOTETYPE system table


Column name Column type Column constraint Table constraints
type_id SMALLINT NOT NULL Primary key
type_name CHAR(128) NOT NULL Unique index
publisher_address LONG VARCHAR NOT NULL
remarks LONG VARCHAR

The SYSREMOTETYPE system table contains information about SQL Remote.

type_id    Identifies which of the of the message systems supported by SQL Remote is to be used to send messages to this user.

type_name    The name of the message system supported by SQL Remote.

publisher_address    The address of the remote database publisher.

remarks    Descriptive comments.


Contents Index SYSREMOTEOPTIONTYPE system table SYSREMOTEUSER system table