A license for erwin DM could not be obtained. The application will shut down. Error codes: 7(-96,491,0)
Cannot launch application after upgrade from 9.x to 9.7 - Error Codes: 7 (-1,359,2)
erwin DM -- How to globally reset Themes in a model ?
erwin DM starts minimized, does not maximize
Why does erwin DM support three different orders for attributes/Columns?
"Enforce Relationship Rules" for Supertype-Subtype Relationships in erwin DM 2018 and later
Complete Compare Alter Script is not generating the Alter Table - Alter Column difference in Column Datatype
DM: Fault Model Name CAEM_CFX.dll (erwin DM Erwin 9.64.01)
When working with an API sheet, get the error: 'This model was created with a newer version of the product and cannot be loaded'
Get "Run-time error Persistence Units Component! Failed while reading a file" error when running an API program for erwin DM

See more

Why do my datatypes in my DDL show as domain names?

Updated November 14, 2016 15:26

Description:

When generating DDL for SQL Server 2005/2008 noticed that all columns are generated with domain name as datatype. Why?

Solution:

When a Domain is created, the option for "Generate as UDD" (User Defined Datatype) is checked by default. This results in generating the DDL with domain as datatype. To generate the syntax with the regular datatype, simply uncheck User Datatype box in Forward Engineer (FE) | Column. It will generate the regular datatype and not the domain as the datatype.

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk