SYSVIEWS system view
1076
SYSVIEWS system view
CREATE VIEW SYS.SYSVIEWS ( vcreator, viewname, viewtext
)
AS
SELECT user_name, table_name, view_def
FROM SYS.SYSTABLE KEY JOIN SYS.SYSUSERPERM
WHERE table_type = ’VIEW’
Lists views along with their definitions.