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