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

8:08 PM To: sqlite-users@sqlite.org Subject: [sqlite] How to Modify Table My database contains the following table: m_Database.ExecNonQuery(_T("CREATE TABLE Vehicles (") _T("VehicleID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,") _T("FK_CustomerID INTEGER NOT NU

[sqlite] How to Modify Table

My database contains the following table: m_Database.ExecNonQuery(_T("CREATE TABLE Vehicles (") _T("VehicleID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,") _T("FK_CustomerID INTEGER NOT NULL,") _T("VehicleNumber INTEGER NOT NULL,") _T("VehicleTitle TEXT,") _T("VehicleMake TEXT,") _T("