Igor Tandetnik wrote:
"q10" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
Is there a way to drop a constraint from a table, something like this:
ALTER TABLE table_name DROP CONSTRAINT constraint_name?
Unfortunately, this command is not supported by SQLite3. Are there
other possibilities?
Rename old table, create new table the way you want it, copy data over,
drop old table.
Igor Tandetnik
Additional performance tip for above - do not recreate the indices on
the new table until you're done inserting the data. That way you'll save
time. And, of course, don't forget to wrap things in a transaction.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
