Reverse Engineering Alias Data Types in SQL Server 2000 - Part II

  • Comments posted here are about the content posted at

  • 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.

  • 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.


    Dave Doyle

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

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