Is there a list what datatype corresponds to the system_type_id in Sys.columns

Is there a list what datatype corresponds to the system_type_id in Sys.columns. I am looking for an easy way to examine the columns we have in the database and i would like to avoid the INFORMATION_SCHEMA.COLUMNS.

Yes you can look in sys.types for such a list or use the type_name function to look up an individual type_id.

StackExchange Database Administrators Q#136671, answer score: 23