information_schema tablosundan alabilirsiniz.
https://dev.mysql.com/doc/refman/8.0...les-table.html

SELECT table_name FROM information_schema.tables WHERE table_schema = 'VERITABANI_ADI'