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

Reverse Engineering Alias Data Types in SQL Server 2000 - Part II Expand / Collapse
Author
Message
Posted Friday, August 24, 2007 5:44 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 7:50 AM
Points: 42, Visits: 429
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/yShlafman/3213.asp
Post #393823
Posted Monday, September 3, 2007 7:16 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, May 4, 2014 5:27 AM
Points: 47, Visits: 80
just a note about something that may be confusing. the article talkes about linking an ADT to a column - this is not a correct concept. ADT just like "standard" datatypes is a part of column's definition. appropriately enough in the example author issues an alter column command to change a data type of the target column. It would have been just as valid to first create an ADT and then use it when creating a new table.
Post #395845
Posted Thursday, September 13, 2007 7:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 2, 2010 10:56 AM
Points: 10, Visits: 15
We have implemented ADTs throughout our database and this is a terrific article to reference when changing the values.  I have often manually altered these and now this provides a sample on how to alter each existing table.


Regards,

Dave Doyle
Post #398931
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse