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

SYSTRIGGER system view Next Page

SYSTYPEMAP system view


The SYSTYPEMAP system view contains the compatibility mapping values for entries in the SYSSQLSERVERTYPE system view. The underlying system table for this view is ISYSTYPEMAP.

Columns
Column name Column type Column constraint
ss_user_type SMALLINT NOT NULL
sa_domain_id SMALLINT NOT NULL
sa_user_type SMALLINT
nullable CHAR(1)

ss_user_type    Contains the Adaptive Server Enterprise user type.

sa_domain_id    Contains the corresponding SQL Anywhere domain_id.

sa_user_type    Contains the corresponding SQL Anywhere user type.

nullable    This field describes whether the type allows NULL values.

Constraints on underlying system table

FOREIGN KEY (sa_domain_id) references SYS.ISYSDOMAIN (domain_id)