Re: drop table and references

Nooooooooooooooooooooooooooooooooo!

If the primary key of that table is foreign key for other tables they have
nothing to refer to. It would be like stripping surnames from people in a
large city.

Regards - Miles Thompson

PS Have you checked the SQL sites which have tutorials on denormalization
of data?
/mt

At 05:28 PM 01/09/2001 -0300, 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?
>
>Saludos... ;-)
>
>--
>System Administration: It's a dirty job,
>but someone told I had to do it.
>-----------------------------------------------------------------
>Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
>Santa Fe - Argentina http://math.unl.edu.ar/~martin/
>Administrador de sistemas en math.unl.edu.ar
>-----------------------------------------------------------------