pcsoft.us.windevCopyright 2026, PC SOFT17 Jan 2018 00:19:00 Z16 Jan 2018 21:48:00 ZHi, I noticed that when creating tables using HCreationIfNotFound() the foreign key constraints (integrity constraints) are not created. I'm talking about mssql server, nor with the regular driver nor with the native driver. When I go into the analysis there is an option to generate an database-create-sql script. Here we have an option to create constraints as well and yes it generates the necessary scripts. But that makes live a bit more complex, whenever I add a new table. Is this by design or 'as expected' or do I miss something?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64035-wd22-sqlserver-foerign-key-constraints/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64035-wd22-sqlserver-foerign-key-constraints-64041/read.awp17 Jan 2018 00:19:00 ZArie, I highly recommend Navicat for managing your external DB's. It's an investment but will save you an incredible amount o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64035-wd22-sqlserver-foerign-key-constraints-64041/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64035-wd22-sqlserver-foerign-key-constraints-64041/read.awpWD22 - sqlserver foerign key constraintsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64035-wd22-sqlserver-foerign-key-constraints-64040/read.awp16 Jan 2018 23:10:00 ZHi Arie, AFAIK, if yo are using an external SQL DB, you are supposed to use the script to create it originally, then do the c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64035-wd22-sqlserver-foerign-key-constraints-64040/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64035-wd22-sqlserver-foerign-key-constraints-64040/read.awpWD22 - sqlserver foerign key constraints