查找包含 xml 字符串值的字段的所有表 [英] Find all tables with a field containing xml string values

问题描述

我有一个 SQL 2005 数据库，我知道数据库中有一个表，其中包含一些 xml 字符串.我怎样才能找到这张表?

I have an SQL 2005 database and I know that in the database there is a table which has got some xml strings in it. How can I find this table(s)?

推荐答案

如果字段实际上是 XML 类型，那么此查询将提供您要查找的内容:

If the fields are actually of type XML, then this query will give you what you're looking for:

select * from information_schema.columns
where DATA_TYPE = 'XML'

马克

这篇关于查找包含 xml 字符串值的字段的所有表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！