It is supposed to create the index if it does not exist already without any errors.
I found the on the sqlite web site at www.sqlite.org/lang_createindex.html, so I expected it to work since the header on the web page is SQL As Understood By SQLite. -----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Monday, January 30, 2006 10:45 AM To: SQLite Subject: [sqlite] Re: Help with IF NOT EXiSTS nbiggs wrote: > I get the following error if I try to use the IF NOT EXISTS function. > If I take out the "IF NOT EXISTS", the statement creates the index. > The same happens when I try using IF NOT EXISTS in a CREATE table > statement. > > CREATE UNIQUE INDEX IF NOT EXISTS idx_table ON table (field1, field2); > SQL error: near "NOT": syntax error I've never seen such syntax. SQLite does not support it. What is it supposed to mean anyway? If you want to create an index unless one exists already, just try to create it and check for failure. Igor Tandetnik
