SHOW commands are used to display metadata, including tables, indexes, procedures, and triggers.
SHOW commands list all of the specified objects or give information about a particular object when used with <name.>
SHOW commands operate on a separate transaction from user statements. They run as
READ COMMITTED background statements and acknowledge all metadata changes immediately.