> "ALTER TABLE ... DROP CONSTRAINT" I view as being a more general
> problem not simply restricted to referential integrity. My comment
> was meant to be strictly interpreted within the realm of RI. Obviously,
> general dropping of columns and constraints needs to be solved, but these
> aren't RI issues specifically.
That's ok, as long as stated somewhere in TODO or whatever.
> And, no, you don't have ALTER TABLE ... ADD CONSTRAINT. What you have
> is the ability to add foreign key constraints only. When this was
This is more than ok:-) Since without ADD CONSTRAINTS, we could not
define a circular referential integrity at all. Good job!
--
Tatsuo Ishii