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

  • Yakov Shlafman

    SSCommitted

    Points: 1613

    Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/yShlafman/3213.asp

  • BitWise MnM

    SSC Eights!

    Points: 859

    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.

  • Dave Doyle

    SSC Enthusiast

    Points: 122

    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

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

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