Hi > Is there any easy way to modify an existing table? I need to do three things: > > 1) add one more column > 2) change the name of one column (keeping the data intact) > 3) rename a table > > Or do I have to read in and then write out the whole database? Although SQLite does not yet support ALTER TABLE statements, you can do those things by creating temporary tables to store the data and dropping and recreating your tables... Search the archive - these questions come quite often...
- Danny -- Danny Reinhold Reinhold Software & Services --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
