Reading a List of Tables

Tables in the Northwind database with table_schema="dbo"
table_name="Orders" and table_type="BASE TABLE"

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	TABLE_TYPE
Northwind	dbo	Orders	BASE TABLE

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	TABLE_TYPE
Northwind	dbo	Alphabetical list of products	VIEW
Northwind	dbo	Category Sales for 1997	VIEW
Northwind	dbo	Current Product List	VIEW
Northwind	dbo	Customer and Suppliers by City	VIEW
Northwind	dbo	Invoices	VIEW
Northwind	dbo	Order Details Extended	VIEW
Northwind	dbo	Order Subtotals	VIEW
Northwind	dbo	Orders Qry	VIEW
Northwind	dbo	Product Sales for 1997	VIEW
Northwind	dbo	Products Above Average Price	VIEW
Northwind	dbo	Products by Category	VIEW
Northwind	dbo	Quarterly Orders	VIEW
Northwind	dbo	Sales by Category	VIEW
Northwind	dbo	Sales Totals by Amount	VIEW
Northwind	dbo	Summary of Sales by Quarter	VIEW
Northwind	dbo	Summary of Sales by Year	VIEW
Northwind	dbo	sysconstraints	VIEW
Northwind	dbo	syssegments	VIEW