Virtual Schema Management

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)

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

deprecated