Direct Pass-through commands, such as SHOW TABLES and DESCRIBE tablename, do not display any results.
This can be avoided by adding a comment:
ENGINE SQLEXA /*QUERY*/ SHOW TABLES ; END