show triggers
| User, date | Message |
|---|---|
|
Written by BubikolRamios
2 years ago Category: General 273 posts since Thu, 14 Jan 10 |
show triggers; /* 0 rows affected, 0 rows found. Duration for 1 query: 0,030 sec. */ False, triggers are there, just don't have (don't know which) privileges to see them. Also triggers are not shown in HSQL tree window, no warnings/errors. Regards |
|
Written by BubikolRamios
2 years ago 273 posts since Thu, 14 Jan 10 |
If any comfort (-:, mysql query browser does the same. |
|
Written by ansgar
2 years ago 3975 posts since Fri, 07 Apr 06 |
If you have no privs to see them what do you expect from Heidi in that case? |
|
Written by BubikolRamios
2 years ago 273 posts since Thu, 14 Jan 10 |
Tell me that I have no privs and which is that I need. I mean I do get that kind of info from time to time from different apps. mybe even form HSQL, can tell out from head now. As it is now, I could panic that all my triggers are gone. |
|
Written by ansgar
2 years ago 3975 posts since Fri, 07 Apr 06 |
Think you need the SUPER privilege on 5.1 servers and below, and on newer servers you need the TRIGGER priv. But I can be wrong. |
|
Please login to leave a reply, or register at first. |