When generating DDL for SQL Server 2005/2008 noticed that all columns are generated with domain name as datatype. Why?
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.