RESET

RESET – reset one or multiple session-level parameters

RESET MODULE ;
RESET ALIAS alias ;
RESET ALIAS * ;

This command allows resetting one or many configuration parameters of the current session.

RESET MODULE

Reset the default module name back to “default” for the current session.

For example, if a module foo contains type FooType, the following is how the SET and RESET commands can be used to alias it:

Copy
# Set the default module to "foo" for the current session.
SET MODULE foo;

# This query is now equivalent to "SELECT foo::FooType".
SELECT FooType;

# Reset the default module for the current session.
RESET MODULE;

# This query will now produce an error.
SELECT FooType;
RESET ALIAS alias

Reset alias for the current session.

For example:

Copy
# Alias the "std" module as "foo".
SET ALIAS foo AS MODULE std;

# Now "std::min()" can be called as "foo::min()" in
# the current session.
SELECT foo::min({1});

# Reset the alias.
RESET ALIAS foo;

# Now this query will error out, as there is no
# module "foo".
SELECT foo::min({1});
RESET ALIAS *

Reset all aliases defined in the current session. This command affects aliases set with SET ALIAS and SET MODULE. The default module will be set to “default”.

Example:

Copy
# Reset all custom aliases for the current session.
RESET ALIAS *;
Copy
RESET MODULE;

RESET ALIAS foo;

RESET ALIAS *;

SET ALIAS command.

Light
Dark
System