Drop/Recreate parent table

[Matt]

I have a parent table that has 2 child tables. I need to drop and
recreate the parent table because there has been a change to one of the
column types. What should I do prior to dropping the table to make
sure that when recreated and reloaded it will identify the child
tables? This may sound like a dumb question. In test, I exported the
data out then dropped the table and recreated it and reloaded the data.
However, after reloading the data, the table doesn't identify the
child tables as being related when I select Show Related in the Control
Center. Did I leave something out of the process before dropping the
table or is there something I still need to do to make the table
recognize its relationship to the other 2 tables? Thanks for any help.
Matt

[Shashi Mannepalli]

You need to re-create the RELATIONSHIP after you drop-re-created the
table.

cheers...
Shashi Mannepalli
Matt wrote:

I have a parent table that has 2 child tables. I need to drop and
recreate the parent table because there has been a change to one of the
column types. What should I do prior to dropping the table to make
sure that when recreated and reloaded it will identify the child
tables? This may sound like a dumb question. In test, I exported the
data out then dropped the table and recreated it and reloaded the data.
However, after reloading the data, the table doesn't identify the
child tables as being related when I select Show Related in the Control
Center. Did I leave something out of the process before dropping the
table or is there something I still need to do to make the table
recognize its relationship to the other 2 tables? Thanks for any help.
Matt