This section describes the DDL commands pertaining to modules.
Create a new module.
create module name [ if not exists ];
There’s a corresponding SDL declaration for a module, although in SDL a module declaration is likely to also include that module’s content.
You may also create a nested module.
create module parent-name::name [ if not exists ];
The command create module
defines a new module for the current
database. The name of the new module must be distinct from any
existing module in the current database. Unlike SDL module
declaration the create module
command does
not have sub-commands, as module contents are created separately.
Normally creating a module that already exists is an error, but with this flag the command will succeed. It is useful for scripts that add something to a module or if the module is missing the module is created as well.