Re: [sqlite] Best way to check for existence of a table?

[Uriel_Carrasquilla]

I got this from Witold Czarnecki:
SELECT NULL FROM sqlite_master WHERE tbl_name = 'your-table';
Regards,

Uriel_Carrasquilla



                      "Richard Boyd"

                      <[EMAIL PROTECTED]        To:
<sqlite-users@sqlite.org>

                      .com>                    cc:

                                               Subject:  [sqlite] Best way
to check for existence of a table?
                      02/13/2005 05:58

                      PM

                      Please respond to

                      sqlite-users







Hi,





I need a way to check if a table exists from some C code. I wrote some code
to try to select a row from a table and then checked the error result.
However, the error code is always â1â (which is just a general
SQLITE_ERROR) if the table does not exist. Is there any way I can
differentiate between the error code meaning âno table foundâ and other
errors?? Or is there a neater way to check for existence of a table?





TIA,


Richard.No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 10/02/2005