Thank you for your replies, Mr. Smith and Mr. Slavin. I made the changes and all is well. Grateful for the assistance...
-- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at mailinglists.sqlite.org] On Behalf Of Simon Slavin > Sent: Monday, March 09, 2015 6:19 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Question about ON DELETE CASCADE > > > On 9 Mar 2015, at 9:11pm, R.Smith <rsmith at rsweb.co.za> wrote: > > >> 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? > > > > There is always a way - but it is dangerous. > > Mister Smith's method should work perfectly. You will, of course, work > on a copy of the database so you have a copy to fall back on if you > mess it up. > > If editing your schema worries you you might like to do something > safer. Another method of changing a database schema is to use the > shell tool to '.dump' the database to a text file. You can then edit > the text file to reflect your desired changes, then use the shell tool > to create a new blank database and '.read' in the modified text file. > > The two methods, if used correctly, will end up with the same result. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users 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.