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!.
2024年9月09日 19:39
Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. <a href="https://electrofusionzone.com/">earbuds</a>
2024年10月22日 14:38
Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. Feel free to visit my website
2024年10月22日 14:40
Wonderful post! We are linking to this great post on our website. Keep up the good writing. pretty handy stuff, overall I imagine this is really worth a bookmark, thanks Feel free to visit my website
2024年10月22日 14:41
I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article. I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.
2024年10月22日 14:43
Thanks for all the tips mentioned in this article! it’s always good to read things you have heard before and are implementing, but from a different perspective, always pick up some extra bits of information.
2024年10月22日 14:44
Magnificent items from you, man. I have consider your stuff prior to and you’re. just too excellent. I actually like what you have bought right here,I read this post fully regarding the difference of most recent and preceding technologies, it’s awesome article.I cant wait to learn far more from you. That is actually a terrific website.
2024年10月22日 14:44
All the best blogs that is very useful for keeping me share the ideas of the future as well this is really what I was looking for, and I am very happy to come here. Thank you very much Feel free to visit my website
2024年10月22日 14:45
Youre so right. Im there with you. Your weblog is definitely worth a read if anyone comes throughout it. Im lucky I did because now Ive received a whole new view of this.
2024年10月22日 14:46
I am so happy to read this. This is the kind of manual that needs to be given and not the random misinformation that’s at the other blogs. Appreciate your sharing this greatest doc
2024年10月22日 14:47
It's amazing. I want to learn your writing skills. In fact, I also have a website. If you are okay, please visit once and leave your opinion. First of all let me tell you, you have got a great blog .I am interested in looking for more of such topics and would like to have further information Thank you.
2024年10月22日 14:48
There have been online casinos around for a long time, with each of them offering various versions of roulette, blackjack, baccarat, and poker with random number generators. With the evolution of new technologies, casinos now have the ability to offer games with real dealers in a live casino environment. This new ability has all of us looking at online casinos and wondering if the new live dealer casinos are fads or the future of online casinos
2024年10月22日 14:49
We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.
2024年10月22日 14:51
I am incapable of reading articles online very often, but I’m happy I did today. It is very well written, and your points are well-expressed. I request you warmly, please, don’t ever stop writing.Do you want to buy the best Chromebook for artists?
2024年10月22日 14:52
Hello to every one, the contents existing at this site are actually remarkable for people knowledge,Pretty! This has been a really wonderful article...Thank you for providing this information.Hello.This article was extremely motivating, particularly because I waas looking for thoughts onn his subjectt lat Sunday.
2024年10月22日 14:54
it's really nice and meanful. it's really cool blog. Linking is very useful thing.you have really helped lots of people who visit blog and provide them usefull information I bookmark this site and will track down your posts often from now on. Much obliged once more
2024年10月22日 14:56
I think commenting is the best part of my blogging – especially here at Pro Blogger. You see I’m not that profound or wise, but many of my readers are. Comments add value to my blog. They take my posts to the next level and often take my ideas in rewarding new directions.”
2024年10月22日 15:06
is everything that deals with clothes, accessories, footwear, jewelry, hairstyle and etc. It is a habitual trend in which a person dresses up in her best, does her make up, wears her accessories and shoes. Looking good is the main aim of fashion
2024年10月22日 15:08
Your article is very interesting. I think this article has a lot of iinformation needed, looking forward to your new posts. Get permission to share .I bookmark this site and will track down your posts often from now on. Much obliged once more
2024年10月22日 15:22
fascinating dialog is value remark. I feel that it is best to compose more on this matter, it may not be an unthinkable theme however generally people are insufficient to chat on such subjects
2024年10月22日 15:23
It is perfect time to make some plans for the future and it is time to be happy. I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it! After reading your article I was amazed.
2024年10月22日 15:37
to read it,Waiting For More new Update and I Already Read your Recent Post its Great Thank..great article. thank you for sharin..Great post. Thank You For Sharing Valuable. information. It is Very Informative article..I urge you to peruse this content it is fun portrayed .
2024年10月22日 15:38
That is a beneficial viewpoint, however isn’t make every sence whatsoever dealing with which mather. Any method thanks in addition to i had make an effort to share your current post straight into delicius but it surely is apparently an issue using your websites is it possible to you should recheck this. many thanks again . I enjoy your personal style of writing.
2024年10月22日 15:51
Pretty useful article. I merely stumbled upon your internet site and wanted to say that I’ve very favored learning your weblog posts. Any signifies I’ll be subscribing with your feed and I hope you publish once additional soon.