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 on
OP it from 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 mai
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
3 matches
Mail list logo