CREATE OR REPLACE VIEW VIEW_PK AS
SELECT t.table_name 表名,t.column_name 主键列 FROM User_Cons_Columns t, User_Constraints t2
where t.constraint_name=t2.constraint_name and t.table_name=t2.table_name and t2.constraint_type='P'
分享程序员开发的那些事...
更新时间：2022-09-17 09:25:02
CREATE OR REPLACE VIEW VIEW_PK AS
SELECT t.table_name 表名,t.column_name 主键列 FROM User_Cons_Columns t, User_Constraints t2
where t.constraint_name=t2.constraint_name and t.table_name=t2.table_name and t2.constraint_type='P'