oracle导出所有表结构及注释

2021-09-16  本文已影响0人  mua_baby

https://www.huaweicloud.com/articles/12524909.html

SELECT B.TABLE_NAME     AS "表名", 
       C.COMMENTS       AS "表说明", 
       B.COLUMN_ID      AS "字段序号", 
       B.COLUMN_NAME    AS "字段名", 
       B.DATA_TYPE      AS "字段数据类型", 
       B.DATA_LENGTH    AS "数据长度", 
       B.DATA_PRECISION AS "整数位", 
       B.DATA_SCALE     AS "小数位", 
       A.COMMENTS       AS "字段说明" 
  FROM ALL_COL_COMMENTS A, ALL_TAB_COLUMNS B, ALL_TAB_COMMENTS C 
WHERE A.TABLE_NAME IN (SELECT U.TABLE_NAME FROM USER_ALL_TABLES U) 
   AND A.OWNER = B.OWNER 
   AND A.TABLE_NAME = B.TABLE_NAME 
   AND A.COLUMN_NAME = B.COLUMN_NAME 
   AND C.TABLE_NAME = A.TABLE_NAME 
   AND C.OWNER = A.OWNER 
ORDER BY A.TABLE_NAME, B.COLUMN_ID 
上一篇 下一篇

猜你喜欢

热点阅读