查询Oracle中某些表或者某张表的信息（备注、主键、owner等）

查询某张或者某些表的整体信息：

/**first**/
select distinct a.table_name,
                 b.comments,
                 A.OWNER,
                 a.tablespace_name,
                 null as is_used
   from all_tables a, all_tab_comments b
where a.table_name = b.table_name
    and a.table_name like '%YOUR_TABLE_SPECIAL_PART%'
    and a.tablespace_name = 'YOUR_TABSPACE_NAME'
  
/**second**/
select distinct a.table_name,
                b.comments,               
                c.constraint_name,
                d.column_name,
                A.OWNER,
                a.tablespace_name,
                null as is_used
from all_tables       a,
       all_tab_comments b,
       all_constraints c,
       all_cons_columns d
where a.table_name = b.table_name
   and b.table_name = c.table_name
   and c.table_name = d.table_name and c.constraint_name = d.constraint_name
   and a.table_name like '%%YOUR_TABLE_SPECIAL_PART%%' and c.constraint_type = 'P'
   and a.tablespace_name = 'YOUR_TABSPACE_NAME'

【编写于 2009-02-13】