AI ์ด์ ์๋ (↓์๊ธฐ์๋ IT)/03. SQL
FK ๊ฑธ๋ ค์๋์ง ํ์ธํ๊ธฐ
๐ฆ DonzBox
2010. 12. 8. 13:27
/* FK ๊ฑธ๋ ค์๋์ง ํ์ธ ์ฟผ๋ฆฌ */
SELECT *
FROM ALL_CONSTRAINTS
WHERE OWNER = 'SSYADM'
AND R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS
WHERE OWNER = 'SSYADM'
AND TABLE_NAME = 'TB_OM001'
)
SELECT *
FROM ALL_CONSTRAINTS
WHERE OWNER = 'SSYADM'
AND R_CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS
WHERE OWNER = 'SSYADM'
AND TABLE_NAME = 'TB_OM001'
)