List data type của toàn database

SELECT distinct ty.name
 FROM sys.tables as t  
 inner join sys.columns AS c on c.object_id = t.object_id
 inner join sys.types AS ty ON c.user_type_id=ty.user_type_id
 inner join sys.schemas s on t.schema_id = s.schema_id

--Nếu muốn thêm các thông tin như tên column, tên table thì chỉnh sửa đôi chút

SELECT distinct ty.name, c.name, t.name 
 FROM sys.tables as t  
 inner join sys.columns AS c on c.object_id = t.object_id
 inner join sys.types AS ty ON c.user_type_id=ty.user_type_id
 inner join sys.schemas s on t.schema_id = s.schema_id
 where ty.name != 'varchar'
 order by t.name