List all table names in particular schema in SQL Server

Article for: Azure SQL Database

The query below lists tables in provided schema .To list tables from all schemas use this query.


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


  • table_name - table name in provided schema


  • One row: represents one table in a schema
  • Scope of rows: all tables in particular schema
  • Ordered by: table name

Sample results

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.