Lu, Huayi e6fa411af0 DWS DEV 830.201 version

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2024-05-16 07:24:04 +00:00

5.5 KiB

Raw Permalink Blame History

SHOW

Function

SHOW shows the current value of a run-time parameter. You can use the SET statement to set these parameters.

Precautions

Some parameters that can be viewed by SHOW are read-only. You can view but cannot modify their values.

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

Show the value of timezone:

1
SHOW timezone;

Show the current setting of the DateStyle parameter:

1
SHOW DateStyle;

Show the current setting of all parameters:

1
SHOW ALL;

Helpful Links

SET, RESET

Parent topic: DDL Syntax

5.5 KiB Raw Permalink Blame History