I always use surrogates as primary key and I use the Data Modeler functionalities to generate them automatically. That is very good but I do not like that it only defines them as NUMERIC. I have defined a domain I would like to use when generating those primary keys but how can I tell Data Modeler to use that domain?

 

To define the default domain for surrogates go to Preferences, Data Modeler, Model, Relational and select that domain from the list of domains:

defaultdomainforsurrogates

 

Now when the tool generates a surrogate primary key it will use the domain definition for it.

 

Advertisements