Thanks again for your time and help. I've been able to identify the index, but it doesn't appear that sqlite will allow such an index to be dropped:
raise OperationalError(ErrorMessage(e)) sqlobject.dberrors.OperationalError: index associated with UNIQUE or PRIMARY KEY constraint cannot be dropped Reading further, it looks like I'll have to do things the hard way: http://stackoverflow.com/questions/1884787/how-do-i-drop-a-constraint-from-a-sqlite-3-6-21-table Best regards, Tim On 13/07/2011 02:01, Oleg Broytman wrote: > On Wed, Jul 13, 2011 at 01:17:42AM +0100, Timothy W. Grove wrote: >> Thanks. That all sounds like what I am looking for. I'm using sqlite3 >> for my backend (with Windows 7, python 2.7, wxpython 2.9, >> SQLObject-1.0.0-py2.6). > For SQLite the query is > > SELECT * FROM sqlite_master WHERE type='index' > > You can use console program sqlite3.exe to connect to your database. > Or you can use GUI program SQLite Database Browser: > http://sqlitebrowser.sourceforge.net/ > > Oleg. ------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
