/* List all tables and other table info belonging to database 'demo'  */
/* Similar to command - show tables */


SELECT  table_name, table_type, engine          # List all table info
FROM    information_schema.TABLES               # from TABLES
WHERE   table_schema  =  'demo'                 # belonging to db 'demo'