Welcome to the Webmaster Forum.
Page 1 of 3 123 LastLast
Results 1 to 15 of 35
  1. #1
    Senior Member
    Join Date
    Jan 2014
    Location
    Banglore
    Posts
    274

    What is a FOREIGN KEY ?

    A FOREIGN KEY constraint prevents any actions that would destroy links between tables with the Corresponding data keys. A simple way to think of a foreign key is that, essentially, it is another field which has a corresponding primary key field .

    A foreign key in one table points to a primary key or unique key on another table. Foreign keys prevent actions that would change rows with foreign key values when there are no primary keys with that value. The foreign key constraints are used to enforce referential integrity

  2. #2
    Senior Member
    Join Date
    Aug 2015
    Posts
    158

    Re: What is a FOREIGN KEY ?

    What’s the purpose / use of primary and foreign keys? Primary and foreign keys are a way in which the constrain associated data together to ensure data in your database stays consistent and to make sure no redundant data is in the database as a consequence of deleting a table or row in one table that disturbs data in other tables that may possibly rely on that information. It can cause both data integrity glitches as well as glitches with your application that uses such database.

  3. #3
    Senior Member
    Join Date
    Jul 2015
    Location
    Delhi
    Posts
    249

    Re: What is a FOREIGN KEY ?

    A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables.

  4. #4
    Senior Member
    Join Date
    Sep 2015
    Posts
    458

    Re: What is a FOREIGN KEY ?

    Foreign keys are defined as the column or combination of column in which data of two column are related to each other.

  5. #5
    Senior Member
    Join Date
    Sep 2015
    Posts
    447

    Re: What is a FOREIGN KEY ?

    Yes it is group of columns in which data of one column is related to another column data.

  6. #6
    Senior Member
    Join Date
    Nov 2015
    Posts
    139

    Re: What is a FOREIGN KEY ?

    A foreign key (FK) is a column or combination of columns that is used to establish and enforce a link between the data in two tables. You can create a foreign key by defining a FOREIGN KEY constraint when you create or modify a table.

  7. #7
    Member
    Join Date
    Oct 2015
    Posts
    38

    Re: What is a FOREIGN KEY ?

    A foreign key, also called a foreign keyword, in a database table is a key from another table that refers to (or targets) a specific key, usually the primary key , in the table being used. A primary key can be targeted by multiple foreign keys from other tables. But a primary key does not necessarily have to be the target of any foreign keys.

  8. #8
    Member
    Join Date
    May 2015
    Location
    Ashapuri Chowk, Barewal Road, Ferozepur Road, Ludhiana - 141012
    Posts
    43

    Re: What is a FOREIGN KEY ?

    A foreign key is a key used to link two tables together. This is sometimes called a referencing key.
    Foreign Key is a column or a combination of columns whose values match a Primary Key in a different table.

  9. #9
    Senior Member
    Join Date
    Nov 2015
    Posts
    139

    Re: What is a FOREIGN KEY ?

    A foreign key (FK) is a column or combination of columns that is used to establish and enforce a link between the data in two tables. You can create a foreign key by defining a FOREIGN KEY constraint when you create or modify a table.

  10. #10
    Senior Member
    Join Date
    Feb 2016
    Posts
    469

    Re: What is a FOREIGN KEY ?

    You can search on Google with keyword "FOREIGN KEY "

  11. #11
    Junior Member
    Join Date
    Feb 2016
    Posts
    19

    Re: What is a FOREIGN KEY ?

    As others have mentioned a foreign key is used in relational databases and is function as a link between two tables, foreign keys (and primary keys) are used to ensure that there is no redundant data in a database.

  12. #12
    Junior Member
    Join Date
    Feb 2016
    Location
    Noida NCR India
    Posts
    10

    Re: What is a FOREIGN KEY ?

    In context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key in the first table.

  13. #13
    Senior Member
    Join Date
    Mar 2016
    Posts
    240

    Re: What is a FOREIGN KEY ?

    Good ideas! I learn many here. Tks all!

  14. #14
    Member
    Join Date
    Mar 2016
    Posts
    82

    Re: What is a FOREIGN KEY ?

    usually the primary key , in the table being used

  15. #15
    Senior Member
    Join Date
    Jan 2016
    Location
    Mumbai
    Posts
    148

    Re: What is a FOREIGN KEY ?

    A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.

    Bulkmailstack

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. Replies: 1
    Last Post: 04-20-2017, 03:44 AM
  2. List of popular foreign social medias
    By kai_uk in forum Social Media & Bookmarking Forums
    Replies: 5
    Last Post: 06-13-2014, 09:02 AM
  3. Best resource to learn a Foreign Language Online
    By kilato in forum General Talk
    Replies: 0
    Last Post: 04-24-2014, 03:30 AM

Bookmarks

Posting Permissions

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

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 140 141 142 143 144 145 146 147 148