ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| ss_user_type | SMALLINT | NOT NULL | Primary key |
| ss_domain_id | SMALLINT | NOT NULL | |
| ss_type_name | VARCHAR (30) | NOT NULL | |
| primary_sa_domain_id | SMALLINT | NOT NULL | |
| primary_sa_user_type | SMALLINT |
This table contains information relating to compatibility with Adaptive Server Enterprise.
ss_user_type A UNSIGNED INT field describing the Adaptive Server Enterprise user type
ss_domain_id A UNSIGNED INT field describing the Adaptive Server Enterprise domain id.
ss_type_name Contains the Adaptive Server Enterprise type name.
primary_sa_domain_id A UNSIGNED INT field containing the Adaptive Server Anywhere primary domain id.
primary_sa_user_type A UNSIGNED INT field containing the Adaptive Server Anywhere primary user type.