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
