SELECT a.name,
b.name,
*
FROM sys.columns a
JOIN sys.types b
ON b.user_type_id = a.user_type_id
WHERE a.object_id = OBJECT_ID('dbo.T_User')
SELECT a.name,
b.name,
*
FROM sys.columns a
JOIN sys.types b
ON b.user_type_id = a.user_type_id
WHERE a.object_id = OBJECT_ID('dbo.T_User')