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

There are no comments. Click here to write the first comment.