DON tables with Foreign Keys Outside the DON schema

0	Hi, is this possible? foreign-keys asked May 05 '13 at 19:00 Ricci 5●1●1●1

One Answer:

oldest newest most voted

Hello Ricci,

what foreign keys do you mean?

If you mean FKs that are created by DataObjects.Net, then the answer is no. DataObjects.Net would not create any objects outside schema(s) controlled by it.

If you mean some other FKs that could be created manually, then it's definitely possible. However if FK is attached to the table that is controlled by DataObjects.Net such key would be removed in the next database upgrade. You could still create FK that is associated with some external table (not managed by DataObjects.Net) and references table that is DO-managed. Such constraint would work. However since DataObjects.Net would be unaware of this external FK, it would be impossible to drop this table or change the referenced columns.

answered May 06 '13 at 05:13

Denis Krjuchkov
1793●2●5

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

toggle preview

community wiki

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

foreign-keys ×9

Asked: May 05 '13 at 19:00

Seen: 3,788 times

Last updated: May 06 '13 at 05:13

Subscription:

Related questions