SQLServerCentral / Discuss Content Posted by Yakov Shlafman / Article Discussions / Article Discussions by Author / Reverse Engineering Alias Data Types in SQL Server 2000 - Part II / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 06:32:26 GMT20RE: Reverse Engineering Alias Data Types in SQL Server 2000 - Part IIhttp://www.sqlservercentral.com/Forums/Topic393823-247-1.aspx<img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'> 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.Thu, 13 Sep 2007 07:11:00 GMTDave DoyleRE: Reverse Engineering Alias Data Types in SQL Server 2000 - Part IIhttp://www.sqlservercentral.com/Forums/Topic393823-247-1.aspxjust 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.Mon, 03 Sep 2007 07:16:00 GMTBitWise MnMReverse Engineering Alias Data Types in SQL Server 2000 - Part IIhttp://www.sqlservercentral.com/Forums/Topic393823-247-1.aspxComments posted here are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/yShlafman/3213.asp">http://www.sqlservercentral.com/columnists/yShlafman/3213.asp</A>Fri, 24 Aug 2007 17:44:00 GMTYakov Shlafman