Is your feature request related to a problem? Please describe.
The SHOW ENUMS statement should be expanded to include an optional FROM clause, which takes either a schema name or a database.schema name. This would bring us in line with the SHOW TABLES statement, which allows for this.