Set​

set – set one or multiple session-level parameters

set module module ;
set alias alias as module module ;

Description​

This command allows altering the configuration of the current session.

Variations​

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:

# 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:

# 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;

Examples​

set module foo;
set alias foo AS module std;

︙