Oracle查询所有表结构和表名称及备注查询当前⽤户所有表明及表结构，⽤and t1.TABLE_NAME='你要查询的表名' 这个表来查出单独表结构。
SELECT
--t1.Table_Name || chr(13) || t3ments      AS "表名称及说明",
t1.Column_Name                                AS "字段名称",
t1.DATA_TYPE                                  AS "数据类型",
t1.DATA_LENGTH                                AS "长度",
t1.NullAble                                  AS "是否为空",
t2.Comments                                  AS "字段说明",
t1.Data_Default                              AS "默认值"
--t4.created                                  AS "建表时间"
--t3ments                                AS "表说明",
FROM cols t1
LEFT JOIN user_col_comments t2
ON t1.Table_name = t2.Table_name
oracle数据库表结构怎么看
AND t1.Column_Name = t2.Column_Name
LEFT JOIN user_tab_comments t3
ON t1.Table_name = t3.Table_name
LEFT JOIN user_objects t4
ON t1.table_name = t4.OBJECT_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='你要查询的表名'
ORDER BY t1.Table_Name, t1.Column_ID;
查询当前表中所有表名称及结构
select distinct t.table_name,tments from user_col_comments t order by t.table_name

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。