- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 3.23, 4.0, 4.1 Reference Manual :: 12 SQL Statement Syntax :: 12.4 Database Administration Statements :: 12.4.5 SHOW Syntax :: 12.4.5.24 SHOW TABLES Syntax
Section Navigation [Toggle]
- 12.4.5 SHOW Syntax
- 12.4.5.1 SHOW BINARY LOGS Syntax
- 12.4.5.2 SHOW BINLOG EVENTS Syntax
- 12.4.5.3 SHOW CHARACTER SET Syntax
- 12.4.5.4 SHOW COLLATION Syntax
- 12.4.5.5 SHOW COLUMNS Syntax
- 12.4.5.6 SHOW CREATE DATABASE Syntax
- 12.4.5.7 SHOW CREATE TABLE Syntax
- 12.4.5.8 SHOW DATABASES Syntax
- 12.4.5.9 SHOW ENGINE Syntax
- 12.4.5.10 SHOW ENGINES Syntax
- 12.4.5.11 SHOW ERRORS Syntax
- 12.4.5.12 SHOW GRANTS Syntax
- 12.4.5.13 SHOW INDEX Syntax
- 12.4.5.14 SHOW INNODB STATUS Syntax
- 12.4.5.15 SHOW LOGS Syntax
- 12.4.5.16 SHOW MASTER STATUS Syntax
- 12.4.5.17 SHOW OPEN TABLES Syntax
- 12.4.5.18 SHOW PRIVILEGES Syntax
- 12.4.5.19 SHOW PROCESSLIST Syntax
- 12.4.5.20 SHOW SLAVE HOSTS Syntax
- 12.4.5.21 SHOW SLAVE STATUS Syntax
- 12.4.5.22 SHOW STATUS Syntax
- 12.4.5.23 SHOW TABLE STATUS Syntax
- 12.4.5.24 SHOW TABLES Syntax
- 12.4.5.25 SHOW VARIABLES Syntax
- 12.4.5.26 SHOW WARNINGS Syntax
SHOW TABLES [{FROM | IN} db_name] [LIKE 'pattern']
SHOW TABLES lists the
non-TEMPORARY tables in a given database. You
can also get this list using the mysqlshow
db_name command.
The output from SHOW TABLES
contains a single column of table names.
If you have no privileges for a table, the table does not show
up in the output from SHOW TABLES
or mysqlshow db_name.
User Comments
Add your own comment.