Oracle表中的主键被当成哪些表的外键

Posted on 2017-04-24 14:23  断弦悠扬  阅读(273)  评论(0编辑  收藏  举报

SELECT B.TABLE_NAME
FROM USER_CONSTRAINTS A
INNER JOIN USER_CONS_COLUMNS B
ON A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
WHERE A.R_CONSTRAINT_NAME = 'PK_TPPES_FND_USER';

Copyright © 2024 断弦悠扬
Powered by .NET 9.0 on Kubernetes