很多时候我们只知道数据表名称 却不知道具体是哪个业务对象，这个时候就可以使用下列语句进行查询：

select

FID
,(select FNAME
  from T_META_OBJECTTYPE_L
  where FID = T_META_OBJECTTYPE_Temp.FID
  and FLOCALEID = 2052) FNAME
,FKERNELXML
,(select
  FNAME
  from T_META_OBJECTTYPE_L
  where FID = T_META_OBJECTTYPE_Temp.FID and FLOCALEID = '2052') FNAME
,Item
from
(select FKERNELXML.query('//TableName') 'Item', * from T_META_OBJECTTYPE)
T_META_OBJECTTYPE_Temp
where convert(varchar(max),Item) like '%T_BOS_COMPOSITEPACKAGE%'