1SET var TO val 2SET var TO 'val' 3SET var TO DEFAULT 4SET var = DEFAULT 5SET TIME ZONE val 6SET TIME ZONE 'val' 7SET TIME ZONE local 8SET TIME ZONE default 9SET local TIME ZONE default 10SET session TIME ZONE default 11SET var FROM CURRENT 12SET XML OPTION DOCUMENT 13SET XML OPTION CONTENT 14show 'x'; 15show x; 16show all; 17reset x; 18reset all; 19reset time zone; 20reset transaction isolation level 21reset session authorization 22reset 'x'; 23