Virtual Schema Management

You are looking at an older version of the documentation. The latest version is found here.

SYSADMIN.createVirtualSchema

This procedure creates a virtual schema.

SQL

SYSADMIN.createVirtualSchema(IN name string NOT NULL, OUT id biginteger NOT NULL RESULT)

This procedure deletes a virtual schema by its ID.

SQL

SYSADMIN.dropVirtualSchema(IN id biginteger NOT NULL)

You can get the ID of the virtual schema you want to drop by querying from the SYSADMIN.VirtualSchemas system table with the following statement:

SQL

SELECT "id", "name", "deletable", "creationDate", "lastModifiedDate", "creator", "modifier" FROM "SYSADMIN.VirtualSchemas";;

This procedure renames a virtual schema.

SYSADMIN.renameVirtualSchema system procedure removed in v2.4.20