Re: [sqlite] how to Add/modify a table in the existing Sqlite database at client side

2011-08-22 Thread Sumit Gupta
Hello, IF you need to do that just to setup your database once, then you can use any of free tools as suggested. Or you can simply run a SQLCommand through your code to drop and recreate a table using Standard SQL Create Table statement. Alter query will work to drop and add column as well.

Re: [sqlite] how to Add/modify a table in the existing Sqlite database at client side

2011-08-22 Thread Jack Hughes
Take a look at Fluent Migrator project it supports modifying SQLite schema. http://lostechies.com/seanchambers/2011/04/02/fluentmigrator-getting-started/ -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Madhankumar Rajaram

[sqlite] how to Add/modify a table in the existing Sqlite database at client side

2011-08-22 Thread Madhankumar Rajaram
Hi, I am using C# windows application(.Net2010) with sqlite, and i need to change the database table. Can you pls let me know, how to add or modify a new column/ table in the existing Sqlite database that is in my client desktop machine. I want the existing database to