|
|
|
|
|
|
|
|
|
Introduction to User Defined Types
User defined types (UDT) are an interesting way to standard your database design. For example, you can declare a column to be of type EMAIL, which is really a varchar(150), rather than going to look (or not looking!) to see what the standard length should be.
|
|
|
|
Duration:
|
2
mins
30
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.31
out of 5
|
|
Publish Date:
|
October 02, 2009
|
|
|
|
About the Author
|
|
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
|
|
References
|
There are no downloads or recommended reading links for this video
|
|
|
Comments
|
|
Very good video.
|
|
|
Cool piece of information to use.
|
|
|
The ability to more easily standardize similar columns is cool... but seems a bit immature in how it was implemented by MS. Anyone know if they plan to make it easier to alter the type so that you don't have to manually search out and fix the columns individually?
|
|
|
some more detail and transaction script explanation should have been included
|
|
|
Great.
|
|
|
thanks, we've discussed using the UDT's and wasn't aware you could no alter them.
|
|
|
Good
|
Must Be Logged In
|
|
|
|
|