Adding a user-defined data type

Note: This dialog box is available only from the Data Maintenance Wizard.

To add a user-defined data type (UDT):

  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, specify these values:
    Field Description/Comments
    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 should 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