ORACLE 外键关联表和字段查询
查看外键关联的对象
select a.owner, --主键拥有者
a.table_name, --主键表
b.column_name, --主键列
c.OWNER, --外键拥有者
c.table_name, --外键表
d.column_name, --外键列,
a.constraint_name --约束名称
from user_constraints a
left join user_cons_columns b
on a.constraint_name=b.constraint_name
left join user_constraints c
on c.R_CONSTRAINT_NAME=a.constraint_name
left join user_cons_columns d
on c.constraint_name=d.constraint_name
where 1=1 and
a.constraint_type='R' --约束类型，R是外键，P是主键，U是唯一性约束
-- and a.table_name='T_B' --需要查看主外键关系的表
and a.constraint_name = 'FK_X' --约束名称
order by a.table_name;
2021年9月13日 21:33
I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject. movies123
2021年9月30日 23:58
Thanks, that was a really cool read! Complete Business Funding List
2021年10月10日 00:59
Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. รับทำ seo สายเทา
2021年10月18日 00:29 That is really nice to hear. thank you for the update and good luck. umrah package from abu dhabi
2021年11月04日 16:44
I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... agen bandarq winrate tinggi
2022年9月15日 22:52
Physical Science is the part of Science known as Physics (PS), every student in class 10th grade studying at Government & Private Schools of the state board can download the AP SSC PS Model Paper 2023 with answers for all topics of the course designed by the board experts based on the new revised syllabus and curriculum of the BSEAP. Either Telugu medium, English medium and Urdu medium students of class 10th can download the AP SSC Physics model papers 2023 to practice with regular revisions and mock tests. AP 10th Physics Model Paper Class teachers and leading institutional experts are prepared those AP 10th Class PS Model Paper 2023 Pdf with answers that support all exam formats of the board such as Summative Assessments (SA-1 & SA-2) and Formative assessments (FA-1, FA-2, FA-3, FA-4) along with Assignments.
2024年1月08日 05:54
This blog is really great. The information here will surely be of some help to me. Thanks!.