SELECT CASE WHEN EXISTS (...) END Staffan
On Thu, Dec 6, 2012 at 5:47 PM, Durga D <durga.d...@gmail.com> wrote: > I have situation in which I want to read particular record if table exists. > Based on that record information, I have to execute some logic on other > tables of the same database. If record doesn't exist I need to create new > table. > > thanks for sharing your ideas. > > > On Thu, Dec 6, 2012 at 5:26 PM, Dave McKee <dra...@scraperwiki.com> wrote: > > > 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 > > > _______________________________________________ > 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