To drop a tenant, regular_tenant, from a multi-tenant table:

DROP TENANT regular_tenant;