Cloud 通过数据库表名反查业务对象 sql语句

admin

1. select
   
2. FID
   
3. ,(select FNAME
   
4.   from T_META_OBJECTTYPE_L
   
5.   where FID = T_META_OBJECTTYPE_Temp.FID
   
6.   and FLOCALEID = 2052) FNAME
   
7. ,FKERNELXML
   
8. ,(select
   
9.   FNAME
   
10.   from T_META_OBJECTTYPE_L
    
11.   where FID = T_META_OBJECTTYPE_Temp.FID and FLOCALEID = '2052') FNAME
    
12. ,Item
    
13. from
    
14. (select FKERNELXML.query('//TableName') 'Item', * from T_META_OBJECTTYPE)
    
15. T_META_OBJECTTYPE_Temp
    
16. where convert(varchar(max),Item) like '%T_SEC_USER%'

复制代码