Information schema views | Internals of Views Meta Data

– Displays views accessable to current user

CREATE VIEW INFORMATION_SCHEMA.VIEWS

AS

SELECT

db_name() AS TABLE_CATALOG,

schema_name(schema_id) AS TABLE_SCHEMA,

name AS TABLE_NAME,

convert(nvarchar(4000),

object_definition(object_id)) AS VIEW_DEFINITION,

convert(varchar(7), CASE with_check_option

WHEN 1 THEN ‘CASCADE’

ELSE ‘NONE’ END) AS CHECK_OPTION,

‘NO’ AS IS_UPDATABLE

FROM

sys.views

Tags:

Post a Comment