Tipos de dato de las columnas de una BD

gistfile1.cs

SELECT 
        DISTINCT 
        TIPO.name 
        , TABLA.name 
        , COL.name 
FROM OKW.SYS.columns COL 
INNER JOIN OKW.SYS.tables TABLA ON COL.object_id = TABLA.object_id 
INNER JOIN OKW.SYS.types TIPO ON COL.system_type_id = TIPO.system_type_id 
WHERE  
     TIPO.name NOT IN ('sysname') 
     AND 
     TABLA.name NOT IN ('sysdiagrams') 
ORDER BY TIPO.name