To avoid unintentionally finding indexes with the given name, you should use:
select * from sqlite_master where type = 'table' and name = 'TABLENAME' -Tom > -----Original Message----- > From: Sergey Startsev [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 31, 2005 7:35 AM > To: Massimo Gaspari > Subject: Re: [sqlite] Simple question > > Hello Massimo, > > Wednesday, August 31, 2005, 7:19:27 PM, you wrote: > > MG> Is there any way to check if a table (in an opened > database) exists? > MG> Something smarter than "SELECT * FROM TABLENAME". ? > > Select * from sqlite_master where name = 'TABLENAME' > > -- > Best regards > > Sergey Startsev > SQLite Analyzer - SQLite database management tool with GUI. > http://www.kraslabs.com/sqlite_analyzer.html > >