You can get all existing tables by MySQL SHOW TABLES statement. Run this statement using any MySQL client like phpMyAdmin etc and get all existing tables. Take an example, this will show you all existing tables in the current database:
If you want to get existing tables of another database instead of current database, take the following example. This will show you all tables of named database.
SHOW TABLES FROM database_name;
Posted in: MySQL