Log-In to post
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
I'm trying to remove a relation from my ERD, but I want to leave its carried fields in the child table.
In particular, I want to remove the relationship M20_PCL_F01 between parent M20_PCL_IDX and child M20_PCL, but maintaining the field PCL_ID in the child (highlighted in the image).
Whenever I remove the relation, Toad automatically removes the field too.
Is there any solution? (besides re-adding the field manually... it is inherited by a number of descendant tables)
When using arrays in Postgres, the default HTML report does not show this. E.g. a column defined as text (Type: Text, Is Array Type: true) is only shown as "Text" in the ER diagram and also as "Text" in the Entities list. There is no indication at all that the column is an array.
It would also be nice if that was shown in the WorkSpace as well, e.g. as Text instead of just Text