OpenEdge SQL delivers a range of features supporting and enabling multi-tenancy, including:

  • Multi-tenant specific SQL statements to create, alter, and drop tenants of an existing database table.
  • Extended support for multi-tenancy in the OpenEdge SQL Data Definition Language (DDL) to create, alter, and drop multi-tenant enabled tables, indexes, and sequence.
  • Extended support for multi-tenancy in the OpenEdge SQL Data Manipulation Language (DML) to select, insert, update, and delete to/from a multi-tenant table.

This topic is intended for existing OpenEdge SQL users who are familiar with the OpenEdge SQL syntax and provides a brief overview of multi-tenant support, and provides use cases for OpenEdge SQL users getting started with multi-tenancy.

For more information about SQL syntax, see OpenEdge SQL Reference.