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

Do not show triggers in database view

User, date Message
Written by ifgitman
3 years ago
Category: Feature discussion
5 posts since Thu, 16 Feb 12
Hi! I'm new using HeidiSQL, and I find it is not intuitive to see when a trigger belongs to a table, and wich are the table's triggers. In adition, the view of the database's objets is full with triggers that are meaningless out of the context of its table.
I think it's better to show it as sub-nodes of the table, like in MySQL-Front.
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
Well triggers are separately managed by MySQL, as you see with SHOW TRIGGERS and SHOW TABLES. And triggers need quite a few GUI controls to be editable, which I would not want to see in the already overcrowded table designer, would you?
Written by ifgitman
3 years ago
5 posts since Thu, 16 Feb 12
I understand your point, but I can't find an easy way to determine wich triggers are on a certain table.
What about adding a new tab in the table designer, beside the "Foreign keys" one? It could list the table's triggers and link to the current trigger designer.
And when seeing the objects in the database, I can find them more quickly when they are sorted by type: first tables, then procedures, then functions, and so on...

Thanks for your answer, and sorry for my english!
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
You can sort triggers by all different columns, including the rightmost "Type" column. Just click on their column headers.
Written by ifgitman
3 years ago
5 posts since Thu, 16 Feb 12
Yes, but it would be better if the tables were first; and the left panel tree view can't be sorted.
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
> would be better if the tables were first

Well, that sounds very cosmetic to me. However, this is how it works in HeidiSQL.
 

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