To view show the type of engine a MySQL table used, we could type:

show table status where name='test';

+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation       | Checksum | Create_options | Comment |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+
| test | InnoDB |      10 | Dynamic    |  855 |             95 |       81920 |               0 |        65536 |         0 |           1196 | 2018-08-23 01:32:15 | 2019-07-08 00:09:18 | NULL       | utf8_general_ci |     NULL |                |         |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+

Although the command is simple, the output is too much. We could also use a slightly more complicated command to output briefly:

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

+------------+--------+
| TABLE_NAME | ENGINE |
+------------+--------+
| test       | InnoDB |
+------------+--------+