Virtual Schema Management

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.

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.