SYSCAPABILITY system view

Each row of the SYSCAPABILITY system view specifies the status of a capability on a remote database server. The underlying system table for this view is ISYSCAPABILITY.

Column name Data type Description
capid INTEGER The ID of the capability, as listed in the SYSCAPABILITYNAME system view.
srvid UNSIGNED INT The server to which the capability applies, as listed in the SYSSERVER system view.
capvalue CHAR(128) The value of the capability.

Constraints on underlying system table

PRIMARY KEY (capid, srvid)
FOREIGN KEY (srvid) references SYS.ISYSSERVER (srvid)