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.