Skip to main content
Skip table of contents

Virtual Schema Management

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

The procedures on this page manage virtual schemas.

SYSADMIN.createVirtualSchema

This procedure creates a virtual schema.

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

SYSADMIN.dropVirtualSchema

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

SYSADMIN.renameVirtualSchema

deprecated

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.