Editing SQL user-defined data types

You can use the Sql Tables form to create or edit user-defined data types (UDDTs).

  1. In the Sql Tables form, select the table for which you want to create a new data type, click SQL Data Types.
  2. In the SQL Data Types form, execute Filter-In-Place and initiate a new record.
  3. Provide this information:
    Schema
    Verify that this is set to dbo.
    Note: We do not currently support the building of IDOs over tables in schemas other than dbo at this time.
    Data Type
    Select the base data type to use, or provide the name of your new UDDT.
    System Data Type
    Select the type of system data on which your UDDT is to be based.

    Depending on the type you choose here, provide appropriate values for the Length, Precision, and Scale attributes.

  4. Save your work and close the SQL Data Types form.
Optionally, to change a data type, SQL Server requires that the data type be dropped and recreated. To drop a data type, it must not be in use by a table, stored procedure, or function. Perform these steps:
  1. Filter for the data type  and verify that the Where Type Used grid is empty.
  2. Select Actions > Delete and save the record to drop the data type.
  3. Select Actions > New, specify the information again, and save the data type record to recreate it.