To display a tables engine, such as InnoDB or MyISAM, first you need to log into your MariaDB or mySQL server or configure passwordless authentication and then use the -e command line option.

Use the show databases command to view the databases you have already created.

show databases;

Something like this should be returned.

+--------------------+
| Database           |
+--------------------+
| information_schema |
| db001              |
| mysql              |
| performance_schema |
+--------------------+

Enter the database you wish to use.  In this example, the database named db001 will be used.

use db001;

Use the show table status command to display the tables engine.

show table status \G

Something like this should be returned.

  Name: table001
Engine: InnoDB