How to find all available System and User Defined Data Types in SQL Server?

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


Leave a Reply

Your email address will not be published.