Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL : Super tenant use cases : Access data as a super tenant
 

Access data as a super tenant

To access data from a multi-tenant table, mtcustomer:
SELECT * FROM Pub.mtcustomer;
The above select statement returns the column values from the rows in the all the tenant partitions.