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