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
