470,641 Members | 1,594 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

Drop/Recreate parent table

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

Jun 7 '06 #1
1 2750
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


Jun 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Marion Jakob | last post: by
2 posts views Thread by Yve | last post: by
5 posts views Thread by Markus | last post: by
7 posts views Thread by wizardry | last post: by
1 post views Thread by Korara | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.