So that the generated DDL are missing the constraint names.
BTW, my intent is to use the generated DDL to essentially replicate the
database and restore the original schema, which is one of the use cases for
the DDL functionality. In the jOOQ manual, the generated alter statements
do have the names for the constraints. So, I don't see what is going on
On Tuesday, November 28, 2017 at 5:53:34 AM UTC-6, Lukas Eder wrote:
And then ran the query that the jOOQ code generator runs:
sys.sysforeignkeys f ON f.constraintid = fc.constraintid
sys.sysconglomerates fg ON fg.conglomerateid = f.conglomerateid
sys.systables ft ON ft.tableid = fg.tableid
sys.sysschemas fs ON ft.schemaid = fs.schemaid
sys.sysconstraints pc ON pc.constraintid = f.keyconstraintid
sys.sysschemas ps ON pc.schemaid = ps.schemaid
cast(fc.type as varchar(32672)) = 'F'
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to [hidden email].