Re: [sqlite] ADD UNIQUE CONSTRAINT

On Sun, Oct 10, 2010 at 3:08 AM, Fadhel Al-Hashim wrote: > Thank you, > > I was wondering about adding a new constraint to an existing column that is > currently holding data. As you can see from the syntax diagram, you can't just add a constraint. You have to add a column. You

Re: [sqlite] ADD UNIQUE CONSTRAINT

Thank you, I was wondering about adding a new constraint to an existing column that is currently holding data. On Sun, Oct 10, 2010 at 10:54 AM, P Kishor wrote: > On Sun, Oct 10, 2010 at 2:45 AM, Fadhel Al-Hashim > wrote: > > Good day, > > > > is it

Re: [sqlite] ADD UNIQUE CONSTRAINT

On Sun, Oct 10, 2010 at 2:45 AM, Fadhel Al-Hashim wrote: > Good day, > > is it possible to Alter a table and add a unique constraint on one or more > columns? > See http://www.sqlite.org/lang_altertable.html In particular -- "The ADD COLUMN syntax is used to add a new column

[sqlite] ADD UNIQUE CONSTRAINT

Good day, is it possible to Alter a table and add a unique constraint on one or more columns? thanks, fadhel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users