SELECT
T1.*, T3.comments "注释",
T4.COLUMN_NAME "主键"
FROM
(
SELECT
T2.table_name "表名",
T2.column_name AS 列名,
T2.data_type AS 数据类型,
T2.data_length 字段长度,
T2.data_precision 整数位,
T2.Data_Scale 小数位,
T2.nullable AS 是否为空
FROM
(
SELECT
table_name
FROM
user_tables
-- WHERE
-- table_name LIKE 'user' || '%'
) T1
LEFT JOIN user_tab_columns T2 ON T1.table_name = T2.table_name
) T1
LEFT JOIN (
SELECT
col.column_name,
col.table_name
FROM
user_constraints con,
user_cons_columns col
WHERE
con.constraint_name = col.constraint_name
AND con.constraint_type = 'P'
--AND COL.table_name LIKE 'user' || '%'
) T4 ON T1."表名" = T4.table_name,
user_col_comments T3
WHERE
T1."表名" = T3.table_name
AND T3.column_name = T1."列名";
查询当前用户下的所有表、字段、注释、主键等信息
最新推荐文章于 2022-08-10 18:31:22 发布