Difference between UDT and UDDT in SQL 2005

microsoft.public.sqlserver.programming

18 Aug 2005 4:34 PM

B.M

Hi,

I've noticed in SQL Server Management Studio (under types branch), the
existing of new object type "User-defined Type"
Is there any difference between User-defined Data Type UDDT and User-defined
Type UDT ?

Thank you

18 Aug 2005 7:16 PM

Tibor Karaszi

Seems like UDDT is the same thing as we have had since 1.0 (sp_addtype, not CREATE TYPE). My guess
is that UDT is CLR types.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"B.M" <mbouarro***@yahoo.com> wrote in message news:%23zHZmKBpFHA.2976@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I've noticed in SQL Server Management Studio (under types branch), the existing of new object
> type "User-defined Type"
> Is there any difference between User-defined Data Type UDDT and User-defined Type UDT ?
>
> Thank you
>