SELECT
t1.column_name AS "字段名称",
t1.data_type AS "数据类型",
t1.data_length AS "长度",
t1.nullable AS "是否为空",
t2.comments AS "字段说明"
FROM
cols t1
LEFT JOIN user_col_comments t2 ON t1.table_name = t2.table_name
AND t1.column_name = t2.column_name
LEFT JOIN user_tab_comments t3 ON t1.table_name = t3.table_name
WHERE
NOT EXISTS (
SELECT
t4.object_name
FROM
user_objects t4
WHERE
t4.object_type = 'TABLE'
AND t4. TEMPORARY = 'Y'
AND t4.object_name = t1.table_name
)
and t1.table_name = 'TB_WFM_WORKFLOWMODEL'
ORDER BY
t1.table_name,
t1.column_id;
数据库设计导出字段
最新推荐文章于 2024-07-15 11:19:54 发布