http://www.sqlite.org/lang_createindex.html shows the optional [DATABASE] DOT for where the index lives, but not for where the indexed table lives. Just in case anyone is keeping track of weird edge cases that are actually being used somewhere and why, I'm modifying a DDL dump from a different database and creating an equivalent structure, my input DDL has two-part tablenames in the CREATE INDEX statements, and working around this syntax limitation isn't going to do anything but slow me down a little.
Cheers! -- "To avoid both financial loss and jail time, we provide security mechanisms, including access control." -- Mike Burrows, 2006 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
