The Information_schema. tables view contains one row for each table in the current database to which the user has access.
13>
14> select top 10 * from Information_schema.tables;
15> GO
TABLE_CATALOG TABLE_SCHEMA
TABLE_NAME VIEW_DEFINITI
ON
CHECK_OPTION
IS_UPDATABLE
-------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------
--------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------
------------
(0 rows affected)
TABLE_CATALOG TABLE_SCHEMA
TABLE_NAME TABLE_TYPE
-------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------
--------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------
master dbo
spt_fallback_db BASE TABLE
master dbo
spt_fallback_dev BASE TABLE
master dbo
spt_fallback_usg BASE TABLE
master dbo
airplane BASE TABLE
master dbo
spt_monitor BASE TABLE
master dbo
spt_values BASE TABLE
master dbo
MSreplication_options BASE TABLE
(7 rows affected)
1>