Post reply

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

  • August 24, 2007 at 5:44 pm

    #197522

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

  • September 3, 2007 at 7:16 am

    #731012

    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.

  • September 13, 2007 at 7:11 am

    #733461

    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 2 (of 2 total)

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