To find the tables list in current db

 SELECT * FROM INFORMATION_SCHEMA.TABLES..


Note: INFORMATION_SCHEMA is base to find the tables, columns, views, constraints, etc