View Information

SHOW Statement

Basic Syntax:


SHOW DATABASES [INTO OUTFILE filename] [FORMAT format]
SHOW PROCESSLIST [INTO OUTFILE filename] [FORMAT format]
SHOW [TEMPORARY] TABLES [{FROM | IN} <db>] [LIKE '<pattern>' | WHERE expr] [LIMIT <N>] [INTO OUTFILE <filename>] [FORMAT <format>]
SHOW DICTIONARIES [FROM <db>] [LIKE '<pattern>'] [LIMIT <N>] [INTO OUTFILE <filename>] [FORMAT <format>]

For more information, please refer to the official documentation

DESCRIBE Statement

Basic Syntax:


DESC|DESCRIBE TABLE [db.]table [INTO OUTFILE filename] [FORMAT format]