Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Accidentally deleted table from Model View

Hi,    I wanted to delete a certain relationship between two tables but instead a complete table was deleted. I marked the relation with the mouse and used the "delete key" to remove it . I see no ...
General Comment
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Anonymous ,

     

    You are correct about the behaviour, if you want to delete the relationship you need to rigth click the relationship.

     

    Also be sure to read the pop up menu that confirms what you are deleting. 

     

    For sure you also do this but I always do a save before doing a change in a relationship or delete a table, that way if I do any mistake I can just close and reopen the file.

     

    Maybe you can post an idea on the ideas part of the forum to get the relationship selected when you click and not the table.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi - this happened to me. I just referenced same table in transform view, which is then added to model. Hope it helps 🙂

MFelix's avatar
MFelix
Super User
4 years ago

Hi Anonymous ,

 

Don't understand what you mean bhy referencing the same table in the transform view?

 

If you delete a table that is not based on another query or referenced then you won't be abble to have it back except by redoing all the table from sracth.

 

If it's a reference one you need to redo the steps in this case the reference one.