8 replies to this topic

[eracha]

Hi all,

I am into writing a script for referential integrity check for mysql DB, but got stocked when I was unable to query all the Foreign keys in the DB. I will greatly appreciate if some good Samaritan can help me formulate a select query to show all foreign keys in the DB. is it even possible:rolleyes:

Many thanks in advance,
Eric

[WingedPanther]

I believe this document will help you with MySQL metadata.

[krishary]

Hey,

please take a look at this:

http: // sqlserver2000.databases.aspfaq.com/schema-how-do-i-find-all-the-foreign-keys-in-a-database [dot] html (sorry i cant post links :O :D )

This has a bit more than you think you need (bit will probably need to accomplish your task).

regards, Kris

[shokosugi]

foreign keys? not sure i understand. but if you want to get all the "child" keys..you can use "IN" or "EXISTS" in your SQL.

you can also use MINUS.

Edited by WingedPanther, 31 October 2008 - 04:39 AM.
Double post

[WingedPanther]

shokosugi: foreign keys are a standard database term. Also, if a question has already been answered 4 months ago, why are you responding?

[Xav]

Post count, I suppose? lol

[nullbyte]

This thread is very evil.

Attached Files

•  untitled.PNG   6.73K   52 downloads

[Egz0N]

nullbyte said:

This thread is very evil.

lol :p

[Xav]

Lol that is a lot of views for only 5 replies.