Hi Friends,

If you ever want to get a list of all System and User defined Data Types info which are available in your SQL Environment you can use this Catalog View.


This catalog view also distinguishes whether a given data type in system defined or user defined.

This is how it shows you the info:




Sarabpreet Anand

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on Twitter  |  Follow me on FaceBook