SHOW « MySQL Utilities « MySQL Tutorial

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.