/* MySQL - list all my tables ---------------------------- */

show tables;


/* Oracle - list all my tables --------------------------- */

SELECT table_name  from user_tables;


/* SQLite - list all my tables --------------------------- */

SELECT name from sqlite_master 
 where type='table' or type='view'


/* SQL Server - list all my tables ----------------------- */
/* not tested */

SELECT name FROM sys.Tables 
 WHERE type_desc = 'USER_TABLE'