Oracle根据表名查询表的主键和唯一索引
查询表的主键列名称SELECT tt.table_name, listagg (tt.column_name, ',') WITHIN GROUP (ORDER BY tt.table_name) as pkFROM ( SELECT uc.table_name, ucc.column_name FROM user_constraints uc, user_cons_columns ucc, user_indexes ui WHERE uc.tab
原创
2020-10-19 09:35:55 ·
955 阅读 ·
0 评论