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.
