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.