User Defined Data Types versus User Defined Types

  • kanejeeves

    SSC-Addicted

    Points: 451

    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: 11363

    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

    Hi ,

    Good article to check

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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply