SHOW (session settings)

The SHOW statement can display the value of either one or all session setting variables. Some of these can also be configured via SET SESSION.

Table of contents


SHOW { parameter_name | ALL }


parameter_name:The name of the session setting which should be printed. See Session settings for available session settings.
ALL:Show the values of all settings.


How helpful was this page?