see all tables in database mysql code example Example 1: mysql show all tables show tables; Example 2: how to check tables in mysql mysql -u user -p