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 chapter 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 on SQL syntax, see OpenEdge Data Management: SQL Reference.