After your database has been selected using the use command eg.

use database;

you can type the show tables command to list all tables within the selected databaseeg.

show tables;