How to view the list of tables in SQL Server in a flat view like SSMS?
How to view the list of tables in SQL Server in a flat view like SSMS?
Currently the tables are showing under each schema. I would like to see one list of all the tables.
Please sign in to leave a comment.
Hi,
There's a way to eliminate some hierarchy elements to show just the tables. However, they will still be shown under the schema they belong to (see screenshot)
Thank you for clarifying this.
You can view the table flat list only for a specific table container at once using the Open List option from the context menu
The table names are already listed under the tables node. I am not sure what Open the list option offers differently.
What I would like to see a tables node under the database node so that I can see one list of all the tables for the schemas. Currently I have to expand every Tables node under each schema. This is cumbersome.
https://youtrack.jetbrains.com/issue/DBE-23534/Add-a-node-under-the-database-node-to-see-all-schema-tables
Please upvote and follow this issue to stay updated.