How to list the table names in a MYSQL database using SELECT statement
In below MySQL command replace 'database-name' with the name of your database and MySQL / mariaDB will list the table names:
# SELECT table_name FROM information_schema.tables WHERE table_schema = 'database-name';