<p>What is the command to list all triggers in a MySQL database?</p>

[{'answer_id': 47364, 'author': 'Harry', 'author_id': 4704, 'author_profile': 'https://Stackoverflow.com/users/4704', 'pm_score': 9, 'selected': True, 'text': '<p>The command for listing all triggers is:</p>\n\n<pre><code>show triggers;\n</code></pre>\n\n<p>or you can access the <code>INFORMATION_SCHEMA</code> table directly by:</p>\n\n<pre><code>select trigger_schema, trigger_name, action_statement\nfrom information_schema.triggers\n</code></pre>\n\n<ul>\n<li>You can do this from version 5.0.10 onwards.</li>\n<li>More information about the <a href="http://dev.mysql.com/doc/refman/5.0/en/triggers-table.html" rel="noreferrer"><code>TRIGGERS</code> table is here</a>.</li>\n</ul>\n'}, {'answer_id': 7257460, 'author': 'sunil', 'author_id': 921665, 'author_profile': 'https://Stackoverflow.com/users/921665', 'pm_score': 4, 'selected': False, 'text': "<p>For showing a particular trigger in a particular schema you can try the following:</p>\n\n<pre><code>select * from information_schema.triggers where \ninformation_schema.triggers.trigger_name like '%trigger_name%' and \ninformation_schema.triggers.trigger_schema like '%data_base_name%'\n</code></pre>\n"}, {'answer_id': 7710970, 'author': 'Kainda', 'author_id': 987431, 'author_profile': 'https://Stackoverflow.com/users/987431', 'pm_score': 4, 'selected': False, 'text': "<p>You can use below to find a particular trigger definition.</p>\n\n<pre><code>SHOW TRIGGERS LIKE '%trigger_name%'\\G\n</code></pre>\n\n<p>or the below to show all the triggers in the database. It will work for MySQL 5.0 and above.</p>\n\n<pre><code>SHOW TRIGGERS\\G\n</code></pre>\n"}, {'answer_id': 18782762, 'author': 'Pragnesh Karia', 'author_id': 1027670, 'author_profile': 'https://Stackoverflow.com/users/1027670', 'pm_score': 4, 'selected': False, 'text': "<p>I hope following code will give you more information.</p>\n\n<pre><code>select * from information_schema.triggers where \ninformation_schema.triggers.trigger_schema like '%your_db_name%'\n</code></pre>\n\n<p>This will give you total 22 Columns in <strong>MySQL version: 5.5.27</strong> and Above</p>\n\n<pre><code>TRIGGER_CATALOG \nTRIGGER_SCHEMA\nTRIGGER_NAME\nEVENT_MANIPULATION\nEVENT_OBJECT_CATALOG\nEVENT_OBJECT_SCHEMA \nEVENT_OBJECT_TABLE\nACTION_ORDER\nACTION_CONDITION\nACTION_STATEMENT\nACTION_ORIENTATION\nACTION_TIMING\nACTION_REFERENCE_OLD_TABLE\nACTION_REFERENCE_NEW_TABLE\nACTION_REFERENCE_OLD_ROW\nACTION_REFERENCE_NEW_ROW\nCREATED \nSQL_MODE\nDEFINER \nCHARACTER_SET_CLIENT\nCOLLATION_CONNECTION\nDATABASE_COLLATION\n</code></pre>\n"}, {'answer_id': 68823913, 'author': 'user14570900', 'author_id': 14570900, 'author_profile': 'https://Stackoverflow.com/users/14570900', 'pm_score': 1, 'selected': False, 'text': '<p>You can use MySQL Workbench:\nConnect to the MySQL Server\nSelect DB</p>\n<ul>\n<li>tables</li>\n<li>on the table name line click the edit icon (looks like a work tool)</li>\n<li>in the table edit window - Click the tab &quot;Triggers&quot;</li>\n<li>on the Triggers list click th eTrigger name to get its source code</li>\n</ul>\n'}, {'answer_id': 69413373, 'author': 'Leon Gomez', 'author_id': 17055440, 'author_profile': 'https://Stackoverflow.com/users/17055440', 'pm_score': 0, 'selected': False, 'text': "<p>This sentence could contribute to solving the problem:</p>\n<pre><code>select LOWER(concat('delimiter |', '\\n', 'create trigger %data_base_name%.', TRIGGER_NAME, '\\n', \n'    ', ACTION_TIMING, ' ', EVENT_MANIPULATION, ' on %data_base_name%.', EVENT_OBJECT_TABLE, ' for each row', '\\n',\nACTION_STATEMENT, '\\n',\n'|')) AS TablaTriggers from information_schema.triggers where \ninformation_schema.triggers.trigger_schema like '%data_base_name%'\n</code></pre>\n"}]
['https://Stackoverflow.com/questions/47363', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/4704/']