Show Variables

The SHOW VARIABLES command returns a result set listing all variables defined in the environment.

show variables;

None.

The result set includes metadata for each variable.

show variables;
select name, value, created_instant from (show variables);