How to List Tables in SQL Server
Last updated July 25, 2026 · By the SaturnSQL team
Query sys.tables for all tables in the current database, or INFORMATION_SCHEMA.TABLES for the portable version. Filter INFORMATION_SCHEMA on TABLE_TYPE = 'BASE TABLE' to exclude views.
SELECT s.name AS schema_name, t.name AS table_name
FROM sys.tables t
JOIN sys.schemas s ON s.schema_id = t.schema_id
ORDER BY s.name, t.name;Portable version
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_SCHEMA, TABLE_NAME;Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free