Adding a user-defined data type

Use the Add User-Defined Type dialog box to create a custom user-defined data type.
Note: This dialog box is available only from the Data Maintenance Wizard.
  1. In the Data Maintenance Wizard, specify the name for your UDT in the SQL Data Type field for a property attribute.
  2. When prompted to create the UDT, respond Yes.
    The wizard opens the Add User-Defined Type dialog box with the Name field already filled in.
  3. In the Add User-Defined Type dialog box, provide these values:
    Schema
    Currently, only dbo is supported.
    System Data Type
    Use the drop-down list to specify what data type the new UDT is to be.
    Length
    Optional. On data types that require or permit a length specification, specify the length.
    Decimal Precision
    Optional. Some data types allow you to specify how many decimal places are to be displayed. Specify that precision level here.
    Scale
    Optional. Some data types allow you to specify the maximum total number of digits the property value can have. Specify that number here.
  4. Click OK.
Related topics