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.