SELECT  
       Schemas.name + '.' + Tables.name TableName, Columns.Name ColumnName, Types.Name DataType   
    FROM  
       sys.schemas Schemas  
          INNER JOIN  
          sys.tables Tables  
             ON Schemas.schema_id = Tables.schema_id  
          INNER JOIN  
          sys.stats Stats  
             ON Tables.object_id = Stats.object_id  
          INNER JOIN  
          sys.stats_columns StatsColumns  
             ON Stats.object_id = StatsColumns.object_id AND   
                Stats.stats_id = StatsColumns.stats_id  
          INNER JOIN  
          sys.columns Columns  
             ON StatsColumns.object_id = Columns.object_id AND   
                StatsColumns.column_id = Columns.column_id  
          INNER JOIN  
             sys.types AS Types  
             ON Columns.system_type_id = Types.system_type_id  
    WHERE   
       Types.name  IN ('image', 'ntext', 'text')