SET

SET – set one or multiple session-level parameters

SET MODULE module ;
SET ALIAS alias AS MODULE module ;

This command allows altering the configuration of the current session.

SET MODULE module

Set the default module for the current section to module.

For example, if a module foo contains type FooType, the following is how the type can be referred to:

Copy
# Use the fully-qualified name.
SELECT foo::FooType;

# Use the WITH clause to define the default module
# for the query.
WITH MODULE foo SELECT foo::FooType;

# Set the default module for the current session ...
SET MODULE foo;
# ... and use an unqualified name.
SELECT FooType;
SET ALIAS alias AS MODULE module

Define alias for the module.

For example:

Copy
# Use the fully-qualified name.
SELECT foo::FooType;

# Use the WITH clause to define a custom alias
# for the "foo" module.
WITH bar AS MODULE foo
SELECT bar::FooType;

# Define "bar" as an alias for the "foo" module for
# the current session ...
SET ALIAS bar AS MODULE foo;
# ... and use "bar" instead of "foo".
SELECT bar::FooType;
Copy
SET MODULE foo;

SET ALIAS foo AS MODULE std;

RESET ALIAS command.

Light
Dark
System