How-to: Group by Content type, then by Scheme?
In the Data Browser, I see my objects group by
- Database
- Schema
- Content type (i.e. Tables, views , routines)
I want my view to be
- Database
- Content type (i.e. Tables, views , routines)
- Schema
or just
- Database
- Content type (i.e. Tables, views , routines)
Is this doable, if not, please consider this as a feature request
Please sign in to leave a comment.
Hi,
We group contents only in order you mentioned:
```
- Database
- Schema
- Content type (i.e. Tables, views , routines)
```.
Could you specify use case for your group format?
Thank you.
hi thanks for your reply
the first thing that comes to mind, is that this is how it is in SSMS (sql server management studio) .. so i would sat familiarity is a solid use case
but it can also be very practical when browsing a new database, you can get one list of all tables , one list of all procedures, one list of all scalar functions etc ...
now i have to go schema by schema, which in databases with a large number of schemas can be very cumbersome
finally, it is a very reasonable request, you are not giving away anything, just allowing a developer or analyst to view the database objects, the way he or she prefers