Another level of grouping in the database Tree Explorer

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

Don't you think the tree is already cluttered enough?

hi anse ,
Thanks for your quick response.
yes, its already cluttered .
But please think about a database with 100's of tables and SPs.

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 :)

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.

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 longerYou just need to update HeidiSQL to the latest build, then rightclick the tree and activate "Group objects by type".

That I had not seen

Then I will have to get rid of my old SQLYog.

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...