Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL : Super tenant use cases : Delete rows of a tenant partition
 

Delete rows of a tenant partition

To delete rows of a tenant, SNCSoftware, in a multi-tenant table, mtcustomer:
DELETE FROM mtcustomer
WHERE custnum = 1428 AND tenantName_tbl (pub.mtcustomer) = 'SNCSoftware';