User Defined Data Types versus User Defined Types

• kanejeeves

  SSC-Addicted

  Points: 451

  More actions

  January 21, 2010 at 8:25 am

  #94416

  In SS Mgmt Studio under Database>Programmability>Types... there are two User-defined type options: Data types and Types. Everything I found by googling talked about UDTs and CLR integration. What's the difference between these two options. I don't want to do CLR integration, but I DO want to be able to define a column once, then use it in different tables, so that I know the definition is the same in all tables.

• peterhe

  SSChampion

  Points: 11469

  More actions

  January 21, 2010 at 2:14 pm

  #1106960

  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.

• amit_adarsh

  Ten Centuries

  Points: 1273

  More actions

  June 29, 2014 at 11:55 pm

  #1725748

  Hi ,

  Good article to check

  http://technet.microsoft.com/en-us/library/ms178069(v=sql.105).aspx