User-Defined Data Type (General Page)

  • Article

Use this page to view or modify properties for a user-defined data type (UDDT).

Options

  • Schema
    Select a schema from a list of all schemas available to the current user. The default selection is the default schema for the current user.

    For Microsoft SQL Server 2000 or SQL Server 7.0, specify the owner of the UDDT. The default value is the current user. A user who does not have sysadmin privileges can select only the current user; a user who has sysadmin privileges can select any owner from a list of database users.

  • Name
    If you are creating a new UDDT, type a unique name to be used across the database to represent the UDDT. The maximum number of characters must match the system sysname data type. The name of an existing user-defined data type is not editable.
  • Data type
    Select the base data type from the list box. The list box displays all data types except for the timestamp data type. The data type of an existing UDDT is not editable.
  • Length/Precision
    Displays the length or precision of the data type as applicable. Length applies to character-based UDDTs; Precision applies only to numeric-based UDDTs. The label changes depending on the data type selected earlier. This box is not editable if the length or precision of the selected data type is fixed.
  • Scale
    Specify the maximum number of decimal digits that can be stored to the right of the decimal point. Scale must be a value from 0 through p, where p is the Precision value. Maximum storage sizes vary, based on the precision. Displayed for numeric and decimal data types only.
  • Allow NULLs
    Specify whether the UDDT can accept NULL values. The nullability of an existing UDDT is not editable.

  • Storage
    Displays the maximum storage size for the UDDT. Maximum storage sizes vary, based on precision.

    For nchar and nvarchar data types, the storage value is always two times the value in Length.

  • Default
    Optionally select a rule or a default to bind to the user-defined data type.
  • Rule
    Optionally select a rule to bind to the user-defined data type.

See Also

Other Resources

Implementing User-defined Types
CREATE TYPE (Transact-SQL)
Data Types (Database Engine)
Working with CLR User-defined Types
CREATE RULE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance