How to use type_name function to get the list of datatypes used by each column in SQL Server 2022

Channel:

java frm

Subscribers:

5,740

Published on December 27, 2022 8:30:01 PM ● Video Link: https://www.youtube.com/watch?v=MOqG8BHunUk

Category:

Tutorial

Duration: 3:17

31 views

0

In this video we are going to see how to use type_name function in SQL Server 2022.
Examples:


SELECT TYPE_NAME(36) AS Type36, TYPE_NAME(62) AS Type62;
GO


SELECT o.name AS obj_name, c.name AS col_name,
TYPE_NAME(c.user_type_id) AS type_name
FROM sys.objects AS o
JOIN sys.columns AS c ON o.object_id = c.object_id
WHERE o.name = 'table_name'
ORDER BY col_name;
GO