Editing SQL User-Defined Data Types

To create or edit data types from the SQL Tables form, click SQL Data Types and then:

  1. Select Actions > New.
  2. Specify the name, base data type, length and precision (if applicable for your base data type) and nullability
  3. Save the record.
  4. 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.
Related topics
Maintaining Tables and Other SQL Schema Elements