List all table names in particular schema in Azure SQL Database

Article for: SQL Server

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

Query

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

Columns

  • table_name - table name in provided schema

Rows

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

Sample results