Chapter 16 System Views
1055
SYSCAPABILITIES system view
CREATE VIEW SYS.SYSCAPABILITIES
AS
SELECT t1.capid,srvid,capname,capvalue
FROM
SYS.SYSCAPABILITY as t1
JOIN SYS.SYSCAPABILITYNAME as t2
ON t1.capid = t2.capid
Presents a readable version of the table SYSCAPABILITY and
SYSCAPABILITYNAME.
To Next Page
Loading...