Am 24.11.2019 um 18:54 schrieb Tom Benedict via 4D_Tech <[email protected]>: > > I have a 4D method which generates a SQL DDL, but it doesn’t include > relations. So now I’m looking at the XML structure file as a possibility.
Look at my Blog http://blog.heintz.net/sql-structure-access/ <http://blog.heintz.net/sql-structure-access/> This does export your structure as SQL table definitions, although without the relations (Foreign Key Constrains in MySQL speak). Source available for a small donation. Adding the export of the constrains should not be too hard, maybe I could do it if you really want to, otherwise here is the syntax: FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) Easy as pie :-) ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
