Home Forums SQL Server 2005 Development User Defined Data Types versus User Defined Types RE: User Defined Data Types versus User Defined Types

  • User defined data type is called alias type in sql 2005, and is based on a native sql data type, e.g. Name as varchar(100);

    User defined type (UDT) means the data type created based on a .net assembly.

    So you can use CREATE TYPE to add the alias types you want and use them in your tables.