On Mon, 29 Oct 2001, Mihai Gheorghiu wrote:
> I have two tables t1 and t2, which have a referential integrity defined like
> t2 references t1. I need to re-create t1, because I'm changing the field
> structure (dropping fields included). So I do a drop t1 followed by a new
> create t1. When I drop t1, I get a notice that the referential integrity
> trigger will be implicitly dropped from t2. Does this mean that I have to
> re-create t2 too?
You should only need to recreate the constraint using ALTER TABLE.