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

SYSARTICLECOL system view Next Page

SYSCAPABILITY system view


Each row of the SYSCAPABILITY system view identifies a capability of a remote server. The underlying system table for this view is ISYSCAPABILITY.

Columns
Column name Column type Column constraint
capid INTEGER NOT NULL
srvid UNSIGNED INT NOT NULL
capvalue CHAR(128) NOT NULL

capid    The ID of the capability, as listed in the SYSCAPABILITYNAME system view.

srvid    The server to which the capability applies, as listed in the SYSSERVER system view.

capvalue    The value of the capability.

Constraints on underlying system table

PRIMARY KEY (capid, srvid)

FOREIGN KEY (srvid) references SYS.ISYSSERVER (srvid)

FOREIGN KEY (capid) references SYS.ISYSCAPABILITYNAME (capid)

See also