`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

Synopsis
Parameters

Synopsis ¶

SHOW { parameter_name | ALL }

Parameters ¶

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.