On 18 Mar 2011, at 9:58am, Paul van Helden wrote: > So my problem is, I need to know how the unique requirement was created in > the first place in order to get rid of it in the appropriate manner. > > One solution would be to parse the SQL field in sqlite_master to look for > the constraint. (I'd prefer not!). I also don't really want to attempt a > DROP INDEX and then fall back to recreating the table since I am generating > scripts.
Surely faster to look for an appropriate INDEX declaration in sqlite_master marked as UNIQUE. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
