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_addtypeSpecifies to include a CREATE DATATYPE statement for each user-defined data type you defined in the Domain Editor.
User DatatypeSpecifies to include the USE USER DATATYPE clause in the CREATE TABLE statement for columns that are based on user-defined data types.
| Copyright © 2013 CA. All rights reserved.
|
ncG1vNJzZmirY2Ourq3ZqKWar6NjsLC5jp6psKGeYsK0e7Kup6mnoql8eoGOfHhkfYKstq93o5qrmmN9pLGmuMSrYqtxW2p6hpq0aHmop5uotaa4xZh9oqSVqHyJoKyFZn6Kp567Zn6PgZylqF%2BIno2rsp6pr52ilK6vsL6MsJuZo5qslr%2FEq5Z9maSWrJXFz56qZ6Ckork%3D