1：在oracle 中查看關(guān)聯(lián)表
select u1.CONSTRAINT_NAME, u1.TABLE_NAME as table_, u2.TABLE_NAME as reference_
from user_constraints u1, user_constraints u2
where
u1.constraint_type='R' and
u1.R_CONSTRAINT_NAME = u2.CONSTRAINT_NAME and
u2.table_name='MVS_B_STUDENT'
posted on 2009-03-04 17:29
七匹狼 閱讀(166)
評(píng)論(0) 編輯 收藏 所屬分類:
oracle