Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL : DBA use cases : Define a multi-tenant sequence
 

Define a multi-tenant sequence

To define a sequence, mtcustomer_sequence, as a multi-tenant sequence:
CREATE SEQUENCE pub.mtcustomer_sequence
     START WITH 100,
     INCREMENT BY 1,
     NOCYCLE
     MULTI_TENANT
     ;