SQL Table Exists?

[tsteward]

How can I find out if a table exists in my sl3 database without it throwing up a window?

Thanks
Tony

 

[Erel]

You can use the sqlite_master table:

    cmd.CommandText = "SELECT COUNT(name) FROM sqlite_master WHERE type = 'table' and name = 'TableYouAreSearchingFor'" 
    Reader.Value = cmd.ExecuteReader
    If reader.GetValue(0) > 0 Then
        ...
    End If
    Reader.Close

 

[tsteward]

Thanks Erel that works a treat.
Why can I find info like that as I wish to learn not just ask questions?

Also

What is the best method for testing if a record exists.
such as WHERE 'ID' = Smith

Thanks Heaps

 

[Erel]

The best source of SQLite information is: www.sqlite.org

You can use COUNT to check if more than 0 records were returned (similar to my previous query).