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

Another level of grouping in the database Tree Explorer

User, date Message
Written by biju_ps
2 years ago
Category: Feature discussion
4 posts since Tue, 02 Oct 12
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


Written by ansgar
2 years ago
4988 posts since Fri, 07 Apr 06
Don't you think the tree is already cluttered enough?
Written by biju_ps
2 years ago
4 posts since Tue, 02 Oct 12
hi anse ,
Thanks for your quick response.
yes, its already cluttered .
But please think about a database with 100's of tables and SPs.
Written by ansgar
2 years ago
4988 posts since Fri, 07 Apr 06
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 :)
Written by oz8hp
2 years ago
6 posts since Mon, 08 Oct 12
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.
Written by ansgar
2 years ago
4988 posts since Fri, 07 Apr 06

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".
Written by oz8hp
2 years ago
6 posts since Mon, 08 Oct 12
That I had not seen smile

Then I will have to get rid of my old SQLYog.
Written by rkrx
1 year ago
1 posts since Thu, 27 Jun 13
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.