I have an entity named NODE with an attribute NODE_ID in it. This attribute NODE_ID is also found in several other tables.
Th reason I want to delete the entity is that changes have been made in the source data base to that entity and I wanted to update the model with the new foreign keys that did not exist before. To do this I opened my data base connection wizard and got the list of entities; then select my NODE entity and dragged it to add into the model. It immediately showed error log entries indicating that connections could not be made to associated tables because the underlying attribute NODE_ID was missing. Those attributes were certainly there previously!
I have embarked on no other delete transactions. It appears that delete object NODE removes ATTRIBUTES containing the text ‘NODE’ too in tables other than NODE???
How can this be? I admit to being a newer user of TDM, but this behaviour has me stumped.