List tables in SQL Server schema

Query below lists all tables in specific schema in SQL Server database.


select schema_name(t.schema_id) as schema_name, as table_name,
from sys.tables t
where schema_name(t.schema_id) = 'Production' -- put schema name here
order by table_name;


  • schema_name - schema name
  • table_name - table name
  • create_date - date the table was created
  • modify_date - date the table was last modified by using an ALTER statement


  • One row represents one table in the database
  • Scope of rows: all tables in the database
  • Ordered by table name

Sample results

You could also get this

Get this interactive HTML data dictionary in minutes with Dataedo.

See live HTML data dictionary sample

Try for free

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.