I have a database which doesnt contain any foreign keys or relations, but i have defined then in my llblgen project.

I'm looking to update the database to represent this setup and was wondering can llblgen generate these sql updates for me?

I know i can for table renames etc but what about manual relations?

Thanks

Which version are you using ?

Matt

Its version 3 and bulid nov 15th

• define the relationships in the entity model
• click validate and adjust relational model data
• export update ddl sql script. It contains the FK constraints (and UC constraints, PK constraints etc.) created from the relationships.

Please consult the manual for this, it contains a how-do-I section, which should get you started with this. (see the model first section in 'concepts' to get a good starting point).