--查找字段所在
SELECT
bb.TABLE_NAME,
bb.COLUMN_NAME ,
aa.COLUMN_ID,
aa.DATA_TYPE,
aa.DATA_LENGTH ,
bb.COMMENTS
FROM
user_tab_cols aa
JOIN user_col_comments bb ON
aa.TABLE_NAME = bb.TABLE_NAME
AND aa.COLUMN_NAME = bb.COLUMN_NAME
JOIN dba_objects cc ON
bb.TABLE_NAME = cc.Object_Name
WHERE
bb.COLUMN_NAME LIKE '%PRODUCTNAME%'
AND DATA_LENGTH<30
AND DATA_TYPE!='UNDEFINED'
AND DATA_TYPE!='CHAR'
ORDER BY
cc.created DESC ,
bb.TABLE_NAME,
aa.COLUMN_ID ;
文章来源地址https://www.toymoban.com/news/detail-552506.html
文章来源:https://www.toymoban.com/news/detail-552506.html
到了这里,关于【SQL】查找多个表中相同的字段的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!