Re: [sqlite] How to Modify Table

Slater, Chad wrote: > > Sqlite does not support modifying the unique constraints on a table: > > http://www.sqlite.org/lang_altertable.html > > So you probably need to do it the 'ol fashioned way: > Perfect--Just what I figured I'd need to do! Thanks! -- View this message in context: http

Re: [sqlite] How to Modify Table

Sqlite does not support modifying the unique constraints on a table: http://www.sqlite.org/lang_altertable.html So you probably need to do it the 'ol fashioned way: BEGIN; CREATE TABLE Vehicles_new ( VehicleID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, FK_CustomerID INTEGER NOT NULL, Veh