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.

Sys.Types.

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

This is how it shows you the info:

Regards

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