Syntax\n------\n\nSHOW [FULL] TABLES [FROM db_name]\n    [LIKE 'pattern' | WHERE expr]\n\nDescription\n-----------\n\nSHOW TABLES lists the tables, sequences and views in a given database.\n\nSHOW TABLES lists the tables (only non-TEMPORARY tables are shown), sequences and views in a given database.\n\nThe LIKE clause, if present on its own, indicates which table names to match. The WHERE and LIKE clauses can be given to select rows using more general conditions, as discussed in Extended SHOW. For example, when searching for tables in the test database, the column name for use in the WHERE and LIKE clauses will be Tables_in_test\n\nThe FULL modifier is supported such that SHOW FULL TABLES displays a second output column. Values for the second column, Table_type, are BASE TABLE for a table, VIEW for a view and SEQUENCE for a sequence.\n\nYou can also get this information using:\n\n``bash\nmariadb-show db_name\n`\n\nSee mariadb-show for more details.\n\nIf you have no privileges for a base table or view, it does not show up in the output from SHOW TABLES or mariadb-show db_name`.\n\nThe information_schema.TABLES table, as well as the SHOW TABLE STATUS statement, provide extended information about tables.\n\nExamples\n--------\n\nSHOW TABLES;\n+----------------------+\n| Tables_in_test       |\n+----------------------+\n| animal_count         |\n| animals              |\n| are_the_mooses_loose |\n| aria_test2           |\n| t1                   |\n| view1                |\n+----------------------+\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables