Skip to main content

List all databases and tables in T-SQL.

-- List Databases
select name from sys.databases;

-- List Tables
select table_catalog [database],
    table_schema [schema],
    table_name name,
    table_type [type]
from information_schema.tables;