"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



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to