OpenEdge SQL delivers the following in language extensions to enable and support multi-tenancy:

  • New 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.

For more information on OpenEdge SQL syntax, see OpenEdge Data Management: SQL Reference.