7> SELECT top 10 * FROM INFORMATION_SCHEMA.TABLES
8> GO
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)
|