How to check what specific processes or applications are accessing what ports on my Windows device?
Cannot launch application after upgrade from 9.x to 9.7 - Error Codes: 7 (-1,359,2)
How to Submit an Idea or Enhancement Request for your erwin Inc. product
I am experiencing random bursts of slowness in my huge 2020 R1 model. Is there anything I can do to speed that up?
How can I switch between Logical and Physical models in erwin DM 2020 R1 - there is no visible option for that?
How to Use Data Modeler to Create Unique Indexes with 'Included Columns' clause in SQL Server
The Scheduler can't reverse engineer my database with a Windows domain user. My jobs fail.
Error "Compile Error: Can’t find project or library" during upload from Excel to Erwin 2019 R1
How do I produce the syntax for Identity in erwin DM for PostgreSQL?
How do I create a function based index in Erwin? PostgreSQL example

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