SELECT * FROM information_schema.tables WHERE table_type='BASE TABLE' AND table_schema='<insert_your_database_name_here>'