mysqlshow - display database, table, and column information


mysqlshow [options] [db_name [tbl_name [col_name]]]

The mysqlshow client can be used to quickly see which databases exist, their tables, or a tableĀ“s columns or indexes.

mysqlshow provides a command-line interface to several SQL SHOW statements.
The same information can be obtained by using those statements directly.

For example, you can issue them from the mysql client program.

Invoke mysqlshow like this:

shell> mysqlshow [options] [db_name [tbl_name [col_name]]]

If no database is given, a list of database names is shown.
If no table is given, all matching tables in the database are shown.

Comments are closed.