Dear Setiawan coba ini
SELECT t.owner CHILD_OWNER, t.table_name CHILD_TABLE, t.constraint_name FOREIGN_KEY_NAME, r.owner PARENT_OWNER, r.table_name PARENT_TABLE, r.constraint_name PARENT_CONSTRAINT FROM user_constraints t, user_constraints r WHERE t.r_constraint_name = r.constraint_name AND t.r_owner = r.owner AND t.constraint_type='R' _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ferry Setiawan Sent: Tuesday, January 30, 2007 9:09 AM To: Indo-Oracle Subject: [Fwd: [indo-oracle] Data Constraint] maaf reposting...SOL -------- Original Message -------- Subject: [indo-oracle] Data Constraint Date: Sat, 27 Jan 2007 09:04:21 +0700 From: Ferry Setiawan <[EMAIL PROTECTED] <mailto:ferry.setiawan%40platinumceramics.com> > Reply-To: [email protected] <mailto:indo-oracle%40yahoogroups.com> To: Indo-Oracle <[email protected] <mailto:indo-oracle%40yahoogroups.com> > Dear All Dengan menggunakan perintah select * from user_constraints hasilnya adalah semua constraint akan muncul tetapi tidak ada data table mana yang di refer. jadi hanya nama constraint dan nama table yang memiliki constraint tersebut. misal TableA --> FK_A_B --> TableB yang muncul adalah FK_A_B dan TableA, nah sekarang bagaimana caranya saya bisa mendapatkan TableB? bagaimana querynya? mohon bantuan teman teman... Thanks Ferry S The information contained in this email is or may be confidential, legally privileged, and proprietary in nature or otherwise protected by law from disclosure and is intended solely for the use of the addressee. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, copying or use of any part of this mail is strictly prohibited and unlawful. If you received this email in error, please immediately notify the sender or our email administrator at [EMAIL PROTECTED] and delete it from your system. Thank you. [Non-text portions of this message have been removed]
