as
select?a.owner?所屬用戶,a.table_name?表名,a.column_name?字段名,a.data_type?字段類型,a.字段長度,a.字段精度,a.是否為空,a.創建日期,a.最後修改日期,?
case?when?a.owner=d.owner?and?a.table_name=d.table_name?and?a.column_name=d.column_name?then?'主鍵'?else?''?end?是否主鍵?
from
(select?a.owner,a.table_name,b.column_name,b.data_type,case?when?b.data_precision?is?null?then?b.data_length?else?data_precision?end?字段長度,
data_scale?字段精度,
decode(nullable,'Y','√','N','×')?是否為空,c.created?創建日期,c.last_ddl_time?最後修改日期?
from?all_tables?a,all_tab_columns?b,all_objects?c?
where?a.table_name=b.table_name?and?a.owner=b.owner
and?a.owner=c.owner
and?a.table_name=c.object_name
and?a.owner='SCOTT'--此處用戶名可以更改，但必須大寫英文
and?c.object_type='TABLE')?a
left?join?
(select?a.owner,a.table_name,a.column_name,a.constraint_name?from?user_cons_columns?a,?user_constraints?b?
where?a.constraint_name?=?b.constraint_name?and?b.constraint_type?=?'P')?d
on?a.owner=d.owner?and?a.table_name=d.table_name?and?a.column_name=d.column_name
order?by?a.owner,a.table_name;