Queries below list tables in a specific schema.
select t.table_name from information_schema.tables t where t.table_schema = 'schema_name' -- put schema name here and t.table_type = 'BASE TABLE' order by t.table_name;
- table_name - name of the table
- One row represents one table
- Scope of rows: all tables in the schema
- Ordered by table name
Result shows list of tables in dbo schema of our test database:
You could also get this
Get this interactive HTML data dictionary in minutes with Dataedo.