Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

User Defined Data Types versus User Defined Types Expand / Collapse
Author
Message
Posted Thursday, January 21, 2010 8:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 19, 2010 8:12 AM
Points: 23, Visits: 77
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.
Post #851298
Posted Thursday, January 21, 2010 2:14 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 1:04 PM
Points: 531, Visits: 431

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.



Post #851573
Posted Sunday, June 29, 2014 11:55 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:25 PM
Points: 698, Visits: 158
Hi ,
Good article to check

http://technet.microsoft.com/en-us/library/ms178069(v=sql.105).aspx
Post #1587504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse