Columns Info in MS SQL

SELECT cl.column_id, cl.name, tp.name
FROM
    sys.tables tb
    INNER JOIN sys.columns cl
        ON tb.object_id = cl.object_id
    INNER JOIN sys.types tp
        ON cl.user_type_id = tp.user_type_id
WHERE
    tb.name = 'TABLE_NAME'
ORDER BY cl.column_id