I didn't see a way to search the mail archive, so hopefully this hasn't been addressed repeatedly in the past...
$ sqlite data.dat SQLite version 2.8.17 Enter ".help" for instructions sqlite> .schema sqlite> CREATE TABLE IF NOT EXISTS t ( foo int ); SQL error: near "NOT": syntax error sqlite> I don't know why this statement isn't working, as it appears in the documentation. Is there a workaround? Thanks, Andrew _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
