Re: [sqlite] why no unique columns on alter table

Probably because altering a table is done by changing the value of column SQL in table 'sqlite_master'. Adding a unique constraint requires value checks. On 12.2.2019 6:15, Mark Wagner wrote: This is mainly for my curiosity. Is there any particular reason that one can't add a unique column

Re: [sqlite] why no unique columns on alter table

there as you mentioned. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Mark Wagner Sent: Monday, February 11, 2019 11:16 PM To: SQLite mailing list Subject: [sqlite] why no unique columns on alter table This is mainly for my

[sqlite] why no unique columns on alter table

This is mainly for my curiosity. Is there any particular reason that one can't add a unique column on an alter table? With a default value of null they would all have unique values by default. Any insight into this would be great. Perhaps there' something obvious I'm missing. -- Mark