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')
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
sys.stats Stats
ON Tables.object_id = Stats.object_id
sys.stats_columns StatsColumns
ON Stats.object_id = StatsColumns.object_id AND
Stats.stats_id = StatsColumns.stats_id
sys.columns Columns
ON StatsColumns.object_id = Columns.object_id AND
StatsColumns.column_id = Columns.column_id
sys.types AS Types
ON Columns.system_type_id = Types.system_type_id
WHERE
Types.name IN ('image', 'ntext', 'text')