Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page How to select all Foreign keys in a database
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-04-2008, 02:28 PM
eracha eracha is offline
Newbie
  
Join Date: Feb 2008
Posts: 4
Rep Power: 0
eracha is on a distinguished road
Default How to select all Foreign keys in a database
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

Many thanks in advance,
Eric
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 03-05-2008, 01:43 PM
WingedPanther's Avatar   
WingedPanther WingedPanther is offline
Super Mod
  
Join Date: Jul 2006
Age: 35
Posts: 1,751
Last Blog:
Game software (GURPS)
Rep Power: 24
WingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to all
Default
I believe this document will help you with MySQL metadata.
__________________
CodeCall Blog | CodeCall Wiki | Shareware | Linux Forum
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 06-27-2008, 10:33 AM
krishary krishary is offline
Newbie
  
Join Date: Jun 2008
Posts: 1
Rep Power: 0
krishary is on a distinguished road
Default Re: How to select all Foreign keys in a database
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 )

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

regards, Kris
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Doubt on database connection!! sania21 Visual Basic Programming 3 12-04-2007 11:14 PM
Retrieving Access Database tigger Visual Basic Programming 0 07-06-2007 12:27 AM
Best program for SQL database manipulation Rhadamanthys Database & Database Programming 3 07-02-2007 02:32 PM
Database and Database Users DevilsCharm Database & Database Programming 2 08-27-2006 10:22 AM
Working with TADO Table MrDiaz Delphi/Python 0 07-03-2006 06:28 PM


All times are GMT -5. The time now is 11:00 PM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

dargueta ........ 93.00000
John ........ 87.50000
Xav ........ 50.00000
MeTh0Dz ........ 20.00000
gaylo565 ........ 18.00000
Johnnyboy ........ 3.00000

Contest Rules

Sponsors

Linux Forums
Electronic Music

Ads