I read in the archive
(http://www.mail-archive.com/[email protected]/msg31637.html) :
"You cannot create the primary key after the fact using ALTER TABLE."
Is it possible to DROP a composite primary key constraint after the fact
with ALTER TABLE? The table was created as follows:
CREATE TABLE [WRDS] (
[ttl] int NOT NULL,
[pos] int NOT NULL,
[wrdid] int NOT NULL,
[edln] varchar(8)
CONSTRAINT [PK_WRDS] PRIMARY KEY ([ttl], [pos], [wrdid])
);
CREATE INDEX [IX_WRDID] ON [WRDS] ([wrdid]);
Thanks
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
