About SHOW Statements
Using SHOW Statements
SHOW statements return the result of the last data definition statement performed against the named database object in the form of a CREATE database_object or ALTER database_object statement.
These statements are particularly useful for application developers who need to develop exact replicas of existing tables, views, triggers, hash and join indexes, stored procedures, user‑defined functions, or macros for purposes of testing new software.
Some SHOW statements optionally return database object definition SQL text in XML format.