Azure Lei Zhang的博客

摘要： CREATE OR REPLACE VIEW VIEW_PK ASSELECT 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... 阅读全文

摘要： create or replace view view_fk asselect a.table_name 外键表, c.column_name 外键列, b.table_name 主键表, d.column_name 主键列, decode(a.validated,'VALIDATED',0,1) 多选from user_constraints a, user_constraints b, use... 阅读全文