Reverse Engineering Alias Data Types in SQL Server 2000 - Part II
-
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/yShlafman/3213.asp
-
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.
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