MySQL helpful SHOW functions, procedures, triggers…

Show triggers: SHOW TRIGGERS STATUS

Show procedures: SHOW PROCEDURE STATUS

Show functions: SHOW FUNCTION STATUS

Show users: SELECT User FROM mysql.user;

Show Foreign Keys for a table:
[mysql]use INFORMATION_SCHEMA;

select TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME,
REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME from KEY_COLUMN_USAGE where
REFERENCED_TABLE_NAME = ‘your table name’;[/mysql]

Leave a Reply