Search Results

1. dev.mysql.com › doc › c-api5.4.49 mysql_list_tables ()

   dev.mysql.com › doc › c-api

   Description Returns a result set consisting of table names in the current database that match the simple regular expression specified by the wild parameter. wild may contain the wildcard characters % or _, or may be a NULL pointer to match all tables. Calling mysql_list_tables () is similar to executing the query SHOW TABLES [LIKE wild].

2. linuxvox.com › blog › list-show-tables-in-a-mysqlList (Show) Tables in a MySQL Database: A Comprehensive Guide

   linuxvox.com › blog › list-show-tables-in-a-mysql

   Jan 16, 2026 · In this guide, we’ll explore **multiple methods** to list tables in a MySQL database, from basic commands to advanced queries that provide detailed metadata. We’ll cover everything from simple table name lists to filtering results, distinguishing between tables and views, and even using command-line tools outside the MySQL shell.

3. Videos

   • 

     0:53

     youtube.com

     MySQL: Showing Tables

     Feb 19, 2014

     11.5K Views

   • 

     8:10

     youtube.com

     MySQL: How to create a TABLE

     Oct 9, 2022

     552.9K Views

   • 

     3:39

     youtube.com

     How to List All Tables in MySQL Database

     Sep 28, 2022

     7.3K Views

   View all

4. www.php.net › manual › frPHP: mysql_list_tables - Manual

   www.php.net › manual › fr

   Liste les tables d'une base de données MySQL spécifiée. Cette fonction est obsolète. Il est préférable d'utiliser la fonction mysql_query () pour effectuer la requête SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] à la place.

5. www.geeksforgeeks.org › mysql › how-to-show-listHow to Show/List Tables in MySQL Database - GeeksforGeeks

   www.geeksforgeeks.org › mysql › how-to-show-list

   Jul 23, 2025 · In MySQL, the SHOW TABLES command is a powerful tool used to list the tables within a specific database. This command provides a convenient way to view the tables that exist in a database without needing to query the database schema directly.

6. www-ppti.ufr-info-p6.jussieu.fr › doc-online › PHPListe les tables d'une base de données MySQL

   www-ppti.ufr-info-p6.jussieu.fr › doc-online › PHP

   Liste les tables d'une base de données MySQL spécifiée. Cette fonction est obsolète. Il est préférable d'utiliser la fonction mysql_query () pour effectuer la requête SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] à la place.

7. www.creationdev.net › docs › phpmysql_list_tables [Ref:fonction-mysql-list-tables.php]

   www.creationdev.net › docs › php

   Liste les tables d'une base de données MySQL spécifiée. Cette fonction est obsolète. Il est préférable d'utiliser la fonction mysql_query () pour effectuer la requête SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] à la place.

8. People also ask

   How do I list tables in a MySQL database?

   • Database Access: Credentials (username/password) with sufficient privileges to view tables in the target database (more on permissions later). The simplest way to list tables in a MySQL database is with the SHOW TABLES command. This command returns a list of table names in the currently selected database.

   List (Show) Tables in a MySQL Database: A Comprehensive Guide

   linuxvox.com/blog/list-show-tables-in-a-mysql-database/

   See all results for this question

   What is a show Tables command in MySQL?

   • In MySQL, The SHOW TABLES command is used to list the tables in a specific database. It provides a simple way to see the tables that exist within a database without having to query the database schema directly. The command returns a result set containing the names of all tables in the selected database.

   How to Show/List Tables in MySQL Database - GeeksforGeeks

   www.geeksforgeeks.org/mysql/how-to-show-list-tables-in-mysql-database/

   See all results for this question

   How to list all tables in a database?

   • Overall, We can use the SHOW TABLE statement to list all tables in a database. Using the SHOW FULL TABLE statement to return an additional column that indicates the object is a view or table. We can also show SHOW TABLE FROM statement to list tables in a database.

   How to Show/List Tables in MySQL Database - GeeksforGeeks

   www.geeksforgeeks.org/mysql/how-to-show-list-tables-in-mysql-database/

   See all results for this question

   How do I show Full tables in MySQL?

   • Use SHOW FULL TABLES to quickly identify views in your database. mysqlshow is a command-line tool (separate from the MySQL shell) that lists databases, tables, or columns. It’s useful for scripting or when you don’t want to log into the MySQL client. options: -u (username), -p (prompt for password), -h (host, for remote databases).

   List (Show) Tables in a MySQL Database: A Comprehensive Guide

   linuxvox.com/blog/list-show-tables-in-a-mysql-database/

   See all results for this question

9. php.joaquinfernandez.net › mysql-list-tablesmysql_list_tables - PHP Manual

   php.joaquinfernandez.net › mysql-list-tables

   Liste les tables d'une base de données MySQL spécifiée. Cette fonction est obsolète. Il est préférable d'utiliser la fonction mysql_query () pour effectuer la requête SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] à la place.