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.