Am working on a schema that lacks FKs completely. Missing lots of PKs. Has a bunch of 1:1 join tables. But at least the table names are very long and the column names often have nothing to do with their purpose

It would be very useful to harvest the entity relationships, and other stuff, from the llblgen pro model. The llblgen pro model contains much more info than the schema. Has anyone developed exports, reports, diagrams (like the inheritance stuff)?

Can someone suggest a way to approach this [idea of reporting]? Via the SDK? Hooking the generation process?

Best, /jhd

You could start with the DDL templates which are generating DDL SQL from the catalog contents of a project. You could extend these templates (the one for your DB) with logic which traverses the entities in the Entities property of the current project.

(It's my understanding you're looking for a way to generate DDL SQL for the schema ? Or is your goal differently?)

(edit) I missed 'eval question' so you don't have the DDL SQL templates available to you (they're only available to customers at the moment).

Everything in the project object graph is available to you, you can write an add-in, a template to emit whatever you want (text, html etc.) or even a tool which consumes the project object graph and does additional processing.

Understood. Thx info.

/jhd