Find out if a key is foreign or not?

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Find out if a key is foreign or not?

    I'm trying to find out if a key in the database is a foreign key and what it
    is linked to.
    This way I could automate lookups instead of coding them all.

    For example:
    If its a foreign key, then
    get foreign key table name, key name, value
    look up result
    display result (a name instead of an id?)

    Thanks


    Troy Stark Guest

  2. Similar Questions and Discussions

    1. Foreign keys tut
      Hi group, Is there anyone out there that knows a good innoDB/foreign keys tutorial. I read upon it on the mysql site, but i find that...
    2. Foreign key
      Hi First, i assume i RTFM but am new to MySQL world so i got some problems. I got 2 tables TABLE1 T1Col1 Varchar(30) PRIMARY KEY TABLE2...
    3. Foreign Languages
      Hello: I am building a Slideshow using an xml file and the titles of each slide are in text nodes of the file. I want these string of text in...
    4. trailing slash issue in Find.find
      require "find" Find.find("/usr/bin/") { |file| puts file } /usr/bin//rmdir /usr/bin//rm /usr/bin//mv /usr/bin//mknod /usr/bin//mkfifo...
    5. foreign key is blank
      I have two forms in a one-to-many relationship. I've also created a data entry form for the two of them using a main form and a subform. The...
  3. #2

    Default Re: Find out if a key is foreign or not?

    What database and version?
    "Troy Stark" <troystarkNO@SPAMhotmail.comPLEASE> wrote in message
    news:gXg5b.3870$Ej.614543@ursa-nb00s0.nbnet.nb.ca...
    > I'm trying to find out if a key in the database is a foreign key and what
    it
    > is linked to.
    > This way I could automate lookups instead of coding them all.
    >
    > For example:
    > If its a foreign key, then
    > get foreign key table name, key name, value
    > look up result
    > display result (a name instead of an id?)
    >
    > Thanks
    >
    >

    Bob Barrows Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139