How to query the database to get all the Table names

SELECT * FROM information_schema.tables  where Table_type=’BASE TABLE’