Quoting gwenn <gwenn.k...@gmail.com>:
If you want, you can verify automatically that all the FK columns have a
type matching the referenced columns by using (and tweaking) an old tool
whose name is 'genfkey' (see http://www.sqlite.org/faq.html#q22 but the
'readme' link is broken).

Thanks for the hint.

Honestly though, I think that the need for an external tool to check this basic
kind of schema-integrity is kind of clumsy.

After all, if one could simply define FK columns so that they have the type
they refer to, there wouldn't even be a problem.

regards,
Christian


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

Reply via email to