Returns one row for each table in the current database that is used in a view. This information schema view returns information about the objects to which the current user has permissions.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA.view_name.
VIEW_CATALOG
nvarchar(128)
View qualifier.
VIEW_SCHEMA
Name of schema that contains the view.
VIEW_NAME
sysname
View name.
TABLE_CATALOG
Table qualifier.
TABLE_SCHEMA
Name of schema that contains the base table.
TABLE_NAME
Base table that the view is based on.
The following example returns one row for each table in the current database that is used in a view.
USE AdventureWorks; GO SELECT VIEW_SCHEMA, VIEW_NAME, TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE ORDER BY TABLE_NAME;