RE: [flexcoders] Re: How to check a table already exist in SQLite?

http://livedocs.adobe.com/flex/3/langref/flash/data/SQLSchema.html -Original Message- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of markflex2007 Sent: 25 August 2008 19:54 To: flexcoders@yaho

RE: [flexcoders] Re: How to check a table already exist in SQLite?

Execute a query and see if the table name exists in the sqlite_master table. From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tim Rowe Sent: Monday, August 25, 2008 5:10 PM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] Re: How to check a table already exist

RE: [flexcoders] Re: How to check a table already exist in SQLite?

If you only want this for when you're actually creating the table, rather than trying to confirm it exists: >From http://www.sqlite.org/lang_createtable.html CREATE [TEMP | TEMPORARY] TABLE [IF NOT EXISTS] [database-name .] table-name ( column-def [, column-def]* [, constraint]* )