Re: [SQLObject] removing a unique constraint

[Timothy W. G. <tim...@si...>]

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.