VIEW_TABLE_USAGE (Transact-SQL)

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.

Column name

Data type

Description

VIEW_CATALOG

nvarchar(128)

View qualifier.

VIEW_SCHEMA

nvarchar(128)

Name of schema that contains the view.

Important noteImportant
Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of an object is to query the sys.objects catalog view or use the OBJECT_SCHEMA_NAME function.

VIEW_NAME

sysname

View name.

TABLE_CATALOG

nvarchar(128)

Table qualifier.

TABLE_SCHEMA

nvarchar(128)

Name of schema that contains the base table.

Important noteImportant
Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of an object is to query the sys.objects catalog view or use the OBJECT_SCHEMA_NAME function.

TABLE_NAME

sysname

Base table that the view is based on.

Examples

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;