primary key definition of primary key in the Free Online Encyclopedia.

primary key

The field (column) in a database table that is indexed and maintains the main sequence of the table. For example, account numbers are typically primary keys. A "composite primary key" is made up of two or more fields (columns) such as region + account number.

primary key [′prī‚mer·ē ′kē]

(computer science)

A key that identifies a record or portion of a record and determines the sequence of records in a file or other data structure.

(database)

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.

Mentioned in	?		References in periodicals archive	?		Encyclopedia browser	?		Full browser	?
No references found	Get acquainted with the SQL recovery software's, designed for the recovery of triggers, views, damaged records, partly damaged records, deleted records, primary keys and other SQL database components. Recover SQL Database Components in Simple Steps by Nucleus Data Recovery / Computers and Internet community The two primary keys to successful SEO are good content and relevant links. 3 Reasons to Use Article Marketing as An SEO Tool by Semul Johnson / Advertising, marketing, public relations community Primary Key Database tables in an RDBMS are obligatory to hold a unique field that distinguishes one particular record separately from others found in the database. What Is the Database Management System in SAP by RavinderYadav24 / Computers and office automation community	primary fault primary fission products primary flat joint primary flow primary fluid primary focus primary frequency primary front primary fuel cell Primary Gas primary geosyncline primary gneiss primary gneissic banding primary great circle primary growth primary gun primary haulage primary high explosive primary hydrogen atom primary hypertension primary hypothermia primary immune response primary index primary instrument primary interstice primary key primary knocked-on atom Primary Komsomol Organization primary lateral sclerosis primary lead primary lesion primary light source primary lights primary low primary magma primary management domain primary measuring element primary member primary meristem Primary Metal primary mineral primary optic axis primary orogeny primary partition Primary Party Organization primary phase primary phase region primary phloem primary photocurrent primary plasticizer primary pollutant	Primary instrument Primary Insurance Amount Primary Integrated View of Models and Simulations primary integration primary integration primary integration primary integration Primary Intelligence Requirement primary intention primary intention healing primary intention healing primary intention healing primary intention healing Primary Inter-LATA Carrier System Primary Inter-LATA Number Primary Interchange Carrier primary interest Primary Interexchange Carrier Primary Interexchange Carrier Charge Primary Interlata Carrier Primary Interop Assembly primary interstice Primary Intrathoracic Malignant Effusion Primary Invasive Malignant Melanoma Primary Inventory Control Activity/Agent Primary Investigations Primary IPTV primary iritis Primary Irritant Contact Dermatitis Primary Junction Box primary key Primary Knock-on Atom primary knocked-on atom Primary Komsomol Organization Primary Landing Site Primary Language Arts Assessment Primary Language Is Not English Primary Lateral Chromatic Aberration Primary lateral sclerosis Primary lateral sclerosis Primary lateral sclerosis Primary lateral sclerosis Primary Lateral Sclerosis, Juvenile Primary Launch Control Center Primary Layer Depth primary lead Primary Lead Teacher Primary Leadership Course Primary Leadership Development Course Primary Leadership Development Program Primary Leadership Programme Primary Leadership Qualification Primary Learning Outcome Primary Learning Support Unit primary lease Primary Leaving Examination primary lesion primary lesion primary lesion primary lesion Primary Level Field Activity

Mentioned in

References in periodicals archive

Encyclopedia browser

Full browser

No references found

Get acquainted with the SQL recovery software's, designed for the recovery of triggers, views, damaged records, partly damaged records, deleted records, primary keys and other SQL database components.

Recover SQL Database Components in Simple Steps by Nucleus Data Recovery / Computers and Internet community

The two primary keys to successful SEO are good content and relevant links.

3 Reasons to Use Article Marketing as An SEO Tool by Semul Johnson / Advertising, marketing, public relations community

Primary Key Database tables in an RDBMS are obligatory to hold a unique field that distinguishes one particular record separately from others found in the database.

What Is the Database Management System in SAP by RavinderYadav24 / Computers and office automation community

primary fault

primary fission products