Oracle 查询表信息

select c.*
  from dba_tables t
  join dba_tab_columns c
    on t.table_name = c.table_name
 where t.owner = 'FSCRECON'
;


--表注释
select * from all_tab_comments t where owner = 'FSCRECON' order BY t.TABLE_NAME;


--表 列
select * from dba_tab_columns where owner = 'FSCRECON';


--列 注释
select * from all_col_comments where owner = 'FSCRECON';


/*   BIN$ 开头的 都是删除了的      */ 
select * from dba_recyclebin t where t.object_name = 'BIN$Kb/e4BSfGOrgU3h7qMACNQ==$0'  ;