Help Center > > Developer Guide> SQL Reference> SQL Syntax> SHOW

SHOW

Updated at: Mar 13, 2020 GMT+08:00

Function

SHOW shows the current value of a run-time parameter.

Precautions

None

Syntax

1
2
3
4
5
6
7
8
9
SHOW 
  { 
    configuration_parameter | 
    CURRENT_SCHEMA | 
    TIME ZONE | 
    TRANSACTION ISOLATION LEVEL | 
    SESSION AUTHORIZATION | 
    ALL 
  };

Parameter description

See Parameter Description in RESET.

Examples

1
2
3
4
5
-- Show the value of timezone:
SHOW timezone;

-- Show all parameters:
SHOW ALL;

Helpful Links

SET, RESET

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel