Skip to Content
0

Turn off domain divergence for PK identity columns

Jul 13 at 09:20 PM

31

avatar image

Hi,

In the context of sql server 2008 and pdm, I have PK fields defined as identity fields through a domain called Id. This domain has the Identity checkbox selected.

When I execute the 'Check model' action I get a lot of Domain divergence messages because the PK fields were referenced in child tables and they were migrated into fields that have the same domain, i.e. Id. Because in some cases the child table had already an identity PK, the identity property of the domain has not been transferred to the field in the child table which is correct. Actually, the identity property should not set for the FK field in the child table, even when the table doesn't have an identity field already.

The domain divergence can also be caused because the FK field in the child table is not mandatory, while the Id domain specifies the field as mandatory.

Two questions:

1. How can I turn off these messages when they are caused by the Identity flag not being set in the child table?

2. How can I tell PD not to set the Identity flag even when the child table doesn't have an identity field already?

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers