Simple tenancy
- Last Updated: January 16, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Multi-tenant tables have a 1-to-1 relationship between a tenant and a table partition. The following figure illustrates a multi-tenant table with one schema definition, and 3 tenants in addition to a default partition.

The figure above illustrates that each tenant has its own table partition to maintain its data in. Each tenant can only see data associated with its own table partition. The super-tenant has access to all the table partitions of a multi-tenant table. When a tenant is deleted, its table partition is deleted.