Dictionary    Maps    Thesaurus    Translate    Advanced >   


Tip: Click Thesaurus above for synonyms. Also, follow synonym links within the dictionary to find definitions from other sources.

1. The Free On-line Dictionary of Computing (30 December 2018)
primary key

    A unique identifier, often an integer, that
   labels a certain row in a table of a relational database.

   When this value occurs in other tables as a reference to a
   particular row in the first table it is called a "foreign
   key".

   Some RDBMSes can generate a new unique identifier each time
   a new row is inserted, others merely allow a column to be
   constrained to contain unique values.

   A table may have multiple candidate keys, from which the
   primary key is chosen.  The primary key should be an arbitrary
   value, such as an autoincrementing integer.  This avoids
   dependence on uniqueness, permanence and format of existing
   columns with real-world meaning (e.g. a person's name) or
   other external identifier (e.g. social security number).

   There should be enough possible primary key values to cater
   for the current and expected number of rows, bearing in mind
   that a wider column will generally be slower to process.

   (2006-05-29)


Common Misspellings >
Most Popular Searches: Define Misanthrope, Define Pulchritudinous, Define Happy, Define Veracity, Define Cornucopia, Define Almuerzo, Define Atresic, Define URL, Definitions Of Words, Definition Of Get Up, Definition Of Quid Pro Quo, Definition Of Irreconcilable Differences, Definition Of Word, Synonyms of Repetitive, Synonym Dictionary, Synonym Antonyms. See our main index and map index for more details.

©2011-2024 ZebraWords.com - Define Yourself - The Search for Meanings and Meaning Means I Mean. All content subject to terms and conditions as set out here. Contact Us, peruse our Privacy Policy