4.1.0.2 oracle模式如何通过系统表获取每个表的主键
SELECT a.table_name, a.constraint_name, b.column_name FROM user_cons_columns b, user_constraints a WHERE a.constraint_type = ‘P’ AND a.constraint_name = b.constraint_name;
2 个赞
4.1.0.2 oracle模式如何通过系统表获取每个表的主键
SELECT a.table_name, a.constraint_name, b.column_name FROM user_cons_columns b, user_constraints a WHERE a.constraint_type = ‘P’ AND a.constraint_name = b.constraint_name;