Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8856

SHOW TRIGGERS FROM <database>.<table>

        Details

        • Type: Task
        • Status: Closed
        • Priority: Minor
        • Resolution: Not a Bug
        • Fix Version/s: N/A
        • Component/s: Triggers
        • 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)

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                It already exists: SHOW TRIGGERS LIKE '<table>'.

                Show
                elenst Elena Stepanova added a comment - It already exists: SHOW TRIGGERS LIKE '<table>' .
                Hide
                Permalink
                f_razzoli Federico Razzoli added a comment -

                Sorry - always thought that it refers to the triggers names.

                Show
                f_razzoli Federico Razzoli added a comment - Sorry - always thought that it refers to the triggers names.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    f_razzoli Federico Razzoli
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: