Re: [sqlite] new file / existing table testing.

[Miha Vrhovnik]

"Tony Harris" <[EMAIL PROTECTED]> je ob 18.6.2006 8:03:03 napisal(a):

>Or is there a way within the api that I haven't found to test for existance of 
>tables?
SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;
SELECT name FROM sqlite_master WHERE type='index' ORDER BY name;

Regards,
Miha