* Shortcuts in TDM3
In TDM3, there’s a great feature (except other more great ones… ) - which is the possibility to display multiple representatives of one object in Workspaces and even in one Workspace.
Please see the Film entity in the sample model.
All Items WS - There’s the Film entity with five attributes and five relationships.
Borrowing WS - There’s the same Film entity with five attributes and only two relationships.
-> As you can see, the view is different but only the view. The Film entity is still the same and must have the same properties and same number of attributes.
In WS, you can see only shortcuts of objects - entities, relationships etc. And you can display them at your convenience, e.g. you can have the Film entity four times in the same WS if you like (four shortcuts of this entity).
* Delete options in TDM3
- Delete (Del)
- Delete Object (CTRL+Del - will be changed to SHIFT+Del)
Via Delete, you delete only shortcuts in WS.
See the Borrowing WS again. There is not the self-relationship Has More Episodes - its shortcut is not here. - However, the FK attribute FilmID Episodes is here, which is correct. The self-relationship exists in the model and is displayed e.g. in another WS with the Film entity. - The Film entity must have its FK attribute as the relationship exists in the model.
Let’s say you have two shortcuts of the Film entity in one WS. If you like to remove one, simply click Delete.
The Delete Object option means you delete object from model. If you press CTRL+Del, the Has More Episodes relationship will be deleted, including all its shortcuts. The appropriate FK attributes will be deleted automatically too.
I am wonder if i deleted the relationship by using DELETE (without CTRL+DELETE) then the table/entities I got will still have that foreign key.
See the info above. + Let me repeat that relationship cannot exist without FK attribute and vice versa. When you create a relationship, FK attribute is created automatically. When you delete relationship-object from model (ctrl+del), the FK attribute is deleted too.
I am wondering if it is possible to remove the foreign key on “Entities or Attribute properties” windows? E.g. I am able to remove the normal attribute on entities properties table, but not the foreign key attribute.
This is not and will not be possible.
…most of the time user will use delete to remove something rather than CTRL+DELETE.
Yes, I agree. I think users will work mostly with shortcuts of objects while modeling on several WS, and will remove shortcuts of objects more often. Therefore, Delete option is here.
CTRL+Delete will be changed to SHIFT+Delete. For better explanation, it will be the same as when you delete files in Windows. First you put them to the Bin (Delete) and then you remove them completely (SHIFT+Delete).
…need to go to Model Explorer and navigate through the Relationship and remove it there.
Select an object (shortcut of object) in WS and press Delete (also Objects menu | Delete).
In Model Explorer, select a shortcut of an object in the Shortcuts folder | right-click | Delete Item.
Delete Object options:
- Select an object (shortcut of object) in WS and press CTRL + Delete (also Objects menu | Delete Object).
- From the Model menu, select an object type (e.g. Relationships). Select an object in the opened dialog (Relationships dialog) and click Delete.
- In Model Explorer, select an object | right-click | Delete Item.
Or provide extra features on “Entity properties” windows to delete the foreign key and provide a pop-up message asked about whether you would like to delete the Relationship as well …etc
It’s not possible (and will not be) to delete relationship via deletion of FK. Why? - Via one relationship more FKs can be transferred. You want to remove one FK and delete the relationship. However, what about other attributes it transfers?
Also, remember that alternate keys can be created and you can connect parent and child entities via them. What if you want to delete an attribute that is part of the AK?
(See the sample model again | All Items WS | the Is Rated Relationship - there’s an example of AK (Title and Director attributes).)
Chi, I hope it’s much clearer now. However, if you need to ask any questions, write us back.
In any case, please feel free to watch instructional movies in the Library section. I’m sure you will find them helpful.
I am sorry about asking the some question again.
No problem. That’s why our TDM support team is here. - To reply, explain and help.
Vladka & TDM