select * from all_tab_cols t where t.column_name=‘ABC‘;

select *        from all_tab_cols t        left join (         select a.table_name, a.constraint_name,  a.column_name, b.constraint_type -- 字段约束类型(P:主键)             from user_cons_columns a           inner join user_constraints b                   on a.constraint_name = b.constraint_name             -- and b.constraint_type = ‘P‘        ) tc         on 1=1          and t.table_name = tc.table_name         and t.column_name = tc.column_name       where 1=1       and t.column_name =  ‘PK_PSNDOC‘  -- 要查询的字段       and tc.constraint_type = ‘P‘  -- 判断是否为主键       ORDER BY t.table_name