Returns one row for each table in the current database for which the current user has permissions.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA.view_name.
TABLE_CATALOG
nvarchar(128)
Table qualifier.
TABLE_SCHEMA
Name of schema that contains the table.
TABLE_NAME
sysname
Table name.
TABLE_TYPE
varchar(10)
Type of table. Can be VIEW or BASE TABLE.
The following example returns all rows from the TABLES view.
TABLES
USE AdventureWorks; GO SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_NAME;