Tim Romano wrote: > 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?
No. If for some reason you need to be able to add and remove unique constraint at will, don't specify the constraint in the table definition, but create a UNIQUE index on the appropriate columns instead. While you can't remove a table constraint, you can always drop an index. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
