ASA SQL Reference
System Tables
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.