Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSSOURCE system view Next Page


The SYSSQLSERVERTYPE system view contains information relating to compatibility with Adaptive Server Enterprise. The underlying system table for this view is ISYSSQLSERVERTYPE.

Column name Column type Column constraint
ss_user_type SMALLINT NOT NULL
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

ss_user_type    The Adaptive Server Enterprise user type.

ss_domain_id    The Adaptive Server Enterprise domain id.

ss_type_name    The Adaptive Server Enterprise type name.

primary_sa_domain_id    The corresponding SQL Anywhere primary domain id.

primary_sa_user_type    The corresponding SQL Anywhere primary user type.

Constraints on underlying system table

PRIMARY KEY (ss_user_type)