A user-defined data type is a named alias of an existing data type in the database. Just like a domain, a user-defined data type specifies data type and other column properties for a column in your database.
Using the Domain Editor, you can define user-defined data types for the target servers that support them. Support is provided for DB2 LUW, SQL Server, and Sybase user-defined data types.
After you create a user-defined data type, you can assign it to columns in your model the same way that you assign a domain They can also be used in forward engineering/schema generation. Using the options in the Forward Engineer Schema Generation dialog, you can generate the selected domain as a user-defined data type in the schema. Otherwise the data type of the domain is used when it includes column information in the CREATE TABLE statement.
Note: You cannot set user-defined data types for any of the standard domains (<default>, Blob, Datetime, Number, and String).
|
Copyright © 2013 CA.
All rights reserved.
|
|