Re: drop table and references

On Tue, 9 Jan 2001, Martin A. Marques wrote:

> I have a big doubt. If I drop a table with a primary key to which other
> tables reference to, what happens? And If I create the table again, just as
> it was, but maybe with another column?

Theoretically (ie, assuming no bugs), when you drop the table the foreign
key constraints are dropped as well.  If you recreate the table the
constraints are not recreated, you'd have to use ALTER TABLE ADD
CONSTRAINT to make them again.