Collection Contents Index SYSUSERPERMS system view Views for Transact-SQL Compatibility pdf/chap16.pdf

Reference Manual
   CHAPTER 16. System Views     

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.


Collection Contents Index SYSUSERPERMS system view Views for Transact-SQL Compatibility pdf/chap16.pdf