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:

1_How_to_find_all_available_System_and_User_Defined_Data_Types_in_SQL_Server

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *