SQL Server Performance

which table has xml fields?

Discussion in 'SQL Server 2005 General DBA Questions' started by shahab03, Oct 11, 2006.

  1. shahab03 Member

    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?

  2. Roji. P. Thomas New Member

    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
  3. shahab03 Member

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

Share This Page