Reverse Engineering Alias Data Types in SQL Server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Yakov Shlafman » Reverse Engineering Alias Data Types in SQL...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Yakov Shlafman

Posted Friday, August 24, 2007 5:44 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 5:21 AM
Points: 33, Visits: 327

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

Post #393823

BitWise MnM

Posted Monday, September 03, 2007 7:16 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:18 AM
Points: 47, Visits: 74

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.

Post #395845

Dave Doyle

Posted Thursday, September 13, 2007 7:11 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 02, 2010 10:56 AM
Points: 10, Visits: 15

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

Post #398931

« Prev Topic | Next Topic »

Permissions