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.