distal-attribute
distal-attribute
distal-attribute
distal-attribute

Another level of grouping in the database Tree Explorer

biju_ps posted 2 years ago in Feature discussion
Now HeidiSQL have ability to group database objects like Tables,SPs,Functions etc. IF we can provide another level then it will be very useful when the number of objects in the gorups are very large for Eg.

+Tables

sales
Purchase
+Temp Tables
tmp_sales
tmp_purchase

+Stored Procedures
+Transactional
proc_sales
proc_purchase

+Reporting
Proc_repo_sales
.
.
.


If Heidi can automatically map objects based on the given prefix then it will be an added advantage.

- Biju


ansgar posted 2 years ago
Don't you think the tree is already cluttered enough?
biju_ps posted 2 years ago
hi anse ,
Thanks for your quick response.
yes, its already cluttered .
But please think about a database with 100's of tables and SPs.
ansgar posted 2 years ago
Well, there are some other approaches to keep the overview:
* use the "Database" tab on the right, which can be filtered (Ctrl+Alt+F)
* organize tables into different databases instead of using prefixes.
* remove some tables :)
oz8hp posted 2 years ago
I second the suggestion from biju_ps
The option to have tables, views, stored procedures and so on as levels in the tree is one of the main reasons for me to still have my old SQLYog installed on my computer.
It has this feature and it is workin like a charm.
ansgar posted 2 years ago

oz8hp wrote: The option to have tables, views, stored procedures and so on as levels in the tree is one of the main reasons for me to still have my old SQLYog



Well, HeidiSQL supports these folders since a few months. No need to use SQLYog any longersmileYou just need to update HeidiSQL to the latest build, then rightclick the tree and activate "Group objects by type".
oz8hp posted 2 years ago
That I had not seen smile

Then I will have to get rid of my old SQLYog.
rkrx posted 1 year ago
Hi,

I would also vote this up. But my solution is a little different.

I would include in an option to Group tables by ^[a-zA-Z0-9]+_+, and then (optional 2. layer) the grouping of SPs, Tables and so on.

+ system
| + tables
| + stored procedures
| + ...
+ user
| + tables
| + stored procedures
| + ...



I think, phpmyadmin does grouping already this way...

Please login to leave a reply, or register at first.