Description\n-----------\n\nThe following SHOW statements can be extended using a WHERE clause and a LIKE clause to refine the results:\n\n SHOW CHARACTER SET\n SHOW COLLATION\n SHOW COLUMNS\n SHOW DATABASES\n SHOW FUNCTION STATUS\n SHOW INDEX\\\\\n SHOW OPEN TABLES\n SHOW PACKAGE STATUS\n SHOW PACKAGE BODY STATUS\n SHOW INDEX\n SHOW PROCEDURE STATUS\n SHOW STATUS\n SHOW TABLE STATUS\n SHOW TABLES\n SHOW TRIGGERS\n SHOW VARIABLES\n\nAs with a regular SELECT, the WHERE clause can be used for the specific columns returned, and the LIKE clause with the regular wildcards.\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/extended-show