which table has xml fields? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

which table has xml fields?

Is there a way to find out which table in a database has xml data type columns? and also is it possible to search these fields for a string? thanks

SELECT OBJECT_NAME(c.object_id), c.name
FROM sys.columns c
INNER JOIN sys.types t
ON c.user_type_id = t.user_type_id
WHERE t.name = ‘xml’ Roji. P. Thomas

I dont get any results when I run this query. Not sure if its searching what I am looking for.