"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