I can see situations in which you might want to create a new table with a name that wasn't already taken: at which point simple knowledge would let you reconsider your choice of table name without affecting the db in any way, success or fail.
On Thu, Dec 6, 2012 at 10:57 AM, Hick Gunter <h...@scigames.at> wrote: > Both applications can be done without external logic using > > CREATE TABLE IF NOT EXISTS ... > (detect that the table is missing AND create it) > > and (if required) > > INSERT OR IGNORE INTO ... > (set missing options to default while keeping pre-set values) > > -----Ursprüngliche Nachricht----- > Von: Stephen Chrzanowski [mailto:pontia...@gmail.com] > Gesendet: Donnerstag, 06. Dezember 2012 11:21 > An: General Discussion of SQLite Database > Betreff: Re: [sqlite] to find table exists or not > > I can think of two reasons why you wouldn't want to blindly delete the > table, but verify that it exists. > > - First run of the program that creates the database from square one. If > the table exists, skip over the create routine and continue. I routinely > do this for creating an Options database (Program preferences, etc) instead > of relying on ini files (In Windows) since they're limited in volume of > data, and the kind of data that can be stored within. > > - If using a temporary table validating that the table exists to begin with > before you start throwing data at it. > > The wrapper I use contains a routine that returns a Boolean if the table > exists or not, so I don't have to rely on constructing SQL statements. > > On Wed, Dec 5, 2012 at 9:57 AM, Hick Gunter <h...@scigames.at> wrote: > > > Why do you only want to see if the table is there? > > > > You can always do > > > > DROP TABLE IF EXISTS ... > > CREATE TABLE ... > > > > to replace the definition or > > > > CREATE TABLE IF NOT EXISTS ... > > > > to keep the old definition. > > > > -----Ursprüngliche Nachricht----- > > Von: Durga D [mailto:durga.d...@gmail.com] > > Gesendet: Mittwoch, 05. Dezember 2012 15:33 > > An: General Discussion of SQLite Database > > Betreff: [sqlite] to find table exists or not > > > > Hi all, > > > > > > I just want to find whether table exists or not in a database. > > > > > > Is it correct query? > > > > > > select distinct tbl_name from sqlite_master where tbl_name = 'abc'; > > > > > > Is there any other better way to find whether table exists or not. > > > > > > Thanks in advance. > > > > > > Regards, > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > -------------------------------------------------------------------------- > > Gunter Hick > > Software Engineer > > Scientific Games International GmbH > > Klitschgasse 2 - 4, A - 1130 Vienna, Austria > > FN 157284 a, HG Wien > > Tel: +43 1 80100 0 > > E-Mail: h...@scigames.at > > > > This e-mail is confidential and may well also be legally privileged. If > > you have received it in error, you are on notice as to its status and > > accordingly please notify us immediately by reply e-mail and then delete > > this message from your system. Please do not copy it or use it for any > > purposes, or disclose its contents to any person as to do so could be a > > breach of confidence. Thank you for your cooperation. > > _______________________________________________ > > 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 > > > -------------------------------------------------------------------------- > Gunter Hick > Software Engineer > Scientific Games International GmbH > Klitschgasse 2 – 4, A - 1130 Vienna, Austria > FN 157284 a, HG Wien > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This e-mail is confidential and may well also be legally privileged. If > you have received it in error, you are on notice as to its status and > accordingly please notify us immediately by reply e-mail and then delete > this message from your system. Please do not copy it or use it for any > purposes, or disclose its contents to any person as to do so could be a > breach of confidence. Thank you for your cooperation. > _______________________________________________ > 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
