SQL Server and Sybase User Data Types

Relationships and Domains › Domains and Data Modeling › Domains in the Physical Model › User Data Type Support Using Domains › Summary of User Data Type Schema Generation Options › SQL Server and Sybase User Data Types

SQL Server and Sybase User Data Types

When you assign the SQL Server or Sybase target server to a model, the General tab in the Domain Editor contains an additional option that lets you generate a domain as a User-defined Data Type. Select the Generate as Udd check box in the General tab to generate the selected domain as a User-defined Data Type. Clear the check box if you want the selected domain to set column properties without being generated as a User-defined Data Type.

Note: If you clear the Generate as Udd check box, the data type of the domain appears in the diagram as the data type.

In the Forward Engineer Schema Generation dialog you can determine how user data types are generated in SQL Server or Sybase. Each option in the Forward Engineer Schema Generation dialog that supports user-defined data types is explained below:

sp_addtype

Specifies to include a CREATE DATATYPE statement for each user-defined data type you defined in the Domain Editor.

User Datatype

Specifies to include the USE USER DATATYPE clause in the CREATE TABLE statement for columns that are based on user-defined data types.

More information:

Define Schema Generation Schema Options

Define Schema Generation Column Options