Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Multi-tenant database : Creating multi-tenant elements : OpenEdge SQL
 
OpenEdge SQL
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.