CODE EXAMPLE FOR SQL

get enginge db mysql

SELECT TABLE_NAME,
       ENGINE
FROM   information_schema.TABLES
WHERE  TABLE_SCHEMA = 'dbname';