[MDEV-8856] SHOW TRIGGERS FROM <database>.<table> Created: 2015-09-27 Updated: 2015-09-28 Resolved: 2015-09-27 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Triggers |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Minor |
| Reporter: | Federico Razzoli | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Description |
|
SHOW TRIGGER command allows to see a list of all triggers, or triggers in the specified database (SHOW TRIGGERS FROM my_db). However, it would be useful to list triggers associated to a certain table. (this can be done with the WHERE clause, but it's a bit verbose) |
| Comments |
| Comment by Elena Stepanova [ 2015-09-27 ] |
|
It already exists: SHOW TRIGGERS LIKE '<table>'. |
| Comment by Federico Razzoli [ 2015-09-28 ] |
|
Sorry - always thought that it refers to the triggers names. |