show all tables in database in mysql server code example Example 1: mysql show all tables show tables; Example 2: show tables mysql SHOW TABLES;