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@math.unl.edu.ar
>Santa Fe - Argentina http://math.unl.edu.ar/~martin/
>Administrador de sistemas en math.unl.edu.ar
>-----------------------------------------------------------------