--Asagidaki sorgu, userdefined data tipine sahip tablolari gosterir. select distinct t.name from sys.tables t inner join sys.columns c on t.object_id=c.object_id inner join sys.types tp on c.user_type_id=tp.user_type_id and tp.is_user_defined=1 group by t.name Order by t.name select t.name,c.name,tp.name from sys.tables t inner join sys.columns c on t.object_id=c.object_id inner join sys.types tp on c.user_type_id=tp.user_type_id and tp.is_user_defined=1 Order by t.name
