Show tables lists the non temporary tables sequences and views in a given database. In relational databases the tables can cross reference one another. How To Determine The Size Of Mysql Databases And Tables Show full tables from in dbname like pattern where expr show tables lists the non temporary tables in a given database.