VARIABLE

  Displays information about the specified variables.

  Format

    SHOW VARIABLE  variable-expression [/qualifier...]

Additional information available:

Command_Qualifiers
/BRIEF          /FULL           /INTERMEDIATE   /OUTPUT         /REMARK
/SCOPE          /TEST_DESCRIPTION               /TYPE           /USAGE
/VALUE
Example