Adding a user-defined data type

注意：This dialog box is available only from the “New Data Maintenance Wizard”.

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

  1. In the “New Data Maintenance Wizard”, specify the name for your UDT in the “SQL Data Type” field for a property attribute.
  2. When WinStudio prompts you to create the UDT, respond “Yes”.
  3. WinStudio opens the “Add User-Defined Type” dialog box with the “Name” field already filled in.
  4. 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.
  5. Click “OK”.
相关主题