MariaDB Tutorial

Display a list of tables

Use the "SHOW TABLES FROM" syntax to display a list of tables.

SHOW TABLES FROM database name;

This is a sample to display a table list with the database name "kimoto system".

SHOW TABLES FROM kimotosystem;

This is a sample output result.

+ ---------------------------- +
| Tables_in_kimotosystem |
+ ---------------------------- +
| book |
| author |
| publisher |
+ ---------------------------- +