데이터 타입 불일치 찾기

데이터 타입 불일치 찾기

 

 

SELECT name, MAX(column_type), MIN(column_type), COUNT(*)            

    FROM        

    (        

    SELECT DISTINCT b.name, c.name + '(' + CONVERT(varchar(10), c.max_length) + ')' column_type        

        FROM sys.tables a    

            inner join sys.columns b on a.object_id = b.object_id

            inner join sys.types c on b.system_type_id = c.system_type_id and b.user_type_id = c.user_type_id

    ) A        

GROUP BY name            

HAVING COUNT(*) > 1            

ORDER BY 4 DESC