Display all table names : SHOW « MySQL Utilities « MySQL Tutorial






  1. MySQL Tutorial
  2. MySQL Utilities
  3. SHOW
mysql> use test
Database changed
mysql>
mysql> SHOW TABLES;
Empty set (0.02 sec)








26.10.SHOW
26.10.1.SHOW COLUMNS and DESCRIBE can display information about the columns in individual INFORMATION_SCHEMA tables.
26.10.2.Use the SHOW statement to find out what databases currently exist on the server:
26.10.3.Display all table names
26.10.4.SHOW CREATE TABLE statement.
26.10.5.SHOW INDEX FROM tbl_name
26.10.6.To see the structure or schema of a database
26.10.7.Show a detailed listing of the columns of your database.