Accessing metadata about SQL database

SHOW DATABASES

SHOW TABLES

-- View column names and data types
DESCRIBE [table_name]

-- View disk usage per column
SHOW TABLE STATUS