All, I want to modify my database so that deleting a row from a parent table will delete all dependant rows in all child tables. According to this page:
https://www.sqlite.org/foreignkeys.html It looks like I have to add ON DELETE CASCADE to the child keys of all child tables. For example: FROM: DatasetID INTEGER REFERENCES UUT_Info TO: DatasetID INTEGER REFERENCES UUT_Info ON DELETE CASCADE Is this correct? If so, do I have to create a new database and repopulate it or is there a way to edit the existing database from the command shell? Thank you, -- Bill Drago Senior Engineer L3 Narda-MITEQ<http://www.nardamicrowave.com/> 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com<mailto:William.Drago at L-3COM.com> CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments.
