Extract table names from Database

Hi, From MSSQL if I want to get a list of all my table names I use:

SELECT table_name FROM INFORMATION_SCHEMA.TABLES where table_type = 'BASE TABLE' ORDER BY table_name ASC

However, doing this on a Maria databse not only gives me my table names but all 'event', 'file' and a host of other tables that I'm not interested in.

Is there a better SELECT statement for getting just my owned table names?

You can use the SHOW command on MySQL and/or MariaDB:

SHOW TABLES;
SHOW TABLES FROM mydb;
SHOW TABLE STATUS FROM mydb;

Many thanks. Perfect!