查看表约束

select a.table_name,a.constraint_name,a.constraint_type,column_name
  from user_constraints A, USER_CONS_COLUMNS B
 where a.table_name = 'TALBE_NAME'   and a.table_name = b.table_name