Yes , I understand that. Infact I was doing that through a script during system startup. I wanted to know whether SQLite provides any API to do the same.
Thanks and Regards, Souvik -----Original Message----- From: sqlite-users-boun...@sqlite.org on behalf of John Stanton Sent: Sat 5/30/2009 5:30 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Deleting database content : SQLite3 API An Sqlite database is just a file. Delete the file when you start your program and when you open the database Sqlite will create a fresh dne, a very low overhead process.. . souvik.da...@wipro.com wrote: > Hello, > > Please let me know if we have an API in SQLite3 which allows me to > retain the database but delete it's content at runtime. The problem I am > facing is that : Every time I restart my system , I need to create the > database. If the database exits already it's contents need to be > deleted. The issue is that the contents of the database varies during > one power ON - Power OFF cycle . As a result , after finding that the > database already exits at the system startup, I cannot just drop the > tables. ( As the table which are present in the existing data base is > not known. ) > > I am using sqlite3wrapped C++ library APIs. > > Thanks and Regards, > Souvik > > > Please do not print this email unless it is absolutely necessary. > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive use of the addressee(s) and may > contain proprietary, confidential or privileged information. If you are not > the intended recipient, you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient should > check this email and any attachments for the presence of viruses. The company > accepts no liability for any damage caused by any virus transmitted by this > email. > > www.wipro.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
