• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. SHOW

SHOW

Function

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

Precautions

None

Syntax

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:
SHOW timezone;

-- Show all parameters:
SHOW ALL;

Helpful Links

SET, RESET