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'
                            )