CINXE.COM
Primaire sleutel - Wikipedia
<!DOCTYPE html> <html class="client-nojs vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-enabled skin-theme-clientpref-day vector-toc-available" lang="nl" dir="ltr"> <head> <meta charset="UTF-8"> <title>Primaire sleutel - Wikipedia</title> <script>(function(){var className="client-js vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-enabled skin-theme-clientpref-day vector-toc-available";var cookie=document.cookie.match(/(?:^|; )nlwikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":[",\t.",".\t,"],"wgDigitTransformTable":["",""], "wgDefaultDateFormat":"dmy","wgMonthNames":["","januari","februari","maart","april","mei","juni","juli","augustus","september","oktober","november","december"],"wgRequestId":"58035508-627b-4148-9813-c47141809503","wgCanonicalNamespace":"","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":0,"wgPageName":"Primaire_sleutel","wgTitle":"Primaire sleutel","wgCurRevisionId":53813117,"wgRevisionId":53813117,"wgArticleId":299523,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["Database","Dataopslag"],"wgPageViewLanguage":"nl","wgPageContentLanguage":"nl","wgPageContentModel":"wikitext","wgRelevantPageName":"Primaire_sleutel","wgRelevantArticleId":299523,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgNoticeProject":"wikipedia","wgCiteReferencePreviewsActive":true,"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":true,"wgPopupsFlags":0, "wgVisualEditor":{"pageLanguageCode":"nl","pageLanguageDir":"ltr","pageVariantFallbacks":"nl"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":true,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":1000,"wgRelatedArticlesCompat":[],"wgEditSubmitButtonLabelPublish":true,"wgULSPosition":"interlanguage","wgULSisCompactLinksEnabled":false,"wgVector2022LanguageInHeader":true,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q934729","wgCheckUserClientHintsHeadersJsApi":["brands","architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"],"GEHomepageSuggestedEditsEnableTopics":true,"wgGETopicsMatchModeEnabled":false,"wgGEStructuredTaskRejectionReasonTextInputEnabled":false,"wgGELevelingUpEnabledForUser":false};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading", "skins.vector.search.codex.styles":"ready","skins.vector.styles":"ready","skins.vector.icons":"ready","ext.wikimediamessages.styles":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","ext.uls.interlanguage":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["site","mediawiki.page.ready","skins.vector.js","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.gadget.Direct-link-to-Commons","ext.gadget.ProtectionTemplates","ext.gadget.InterProjectLinks","ext.gadget.hoofdbetekenis-titelwijziging","ext.gadget.switcher","ext.gadget.OpenStreetMapFrame","ext.gadget.subpages","ext.urlShortener.toolbar","ext.centralauth.centralautologin","mmv.bootstrap","ext.popups","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.eventLogging","ext.wikimediaEvents","ext.navigationTiming","ext.uls.interface","ext.cx.eventlogging.campaigns","ext.cx.uls.quick.actions","wikibase.client.vector-2022", "ext.checkUser.clientHints","ext.growthExperiments.SuggestedEditSession"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=nl&modules=ext.uls.interlanguage%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediaBadges%7Cext.wikimediamessages.styles%7Cskins.vector.icons%2Cstyles%7Cskins.vector.search.codex.styles%7Cwikibase.client.init&only=styles&skin=vector-2022"> <script async="" src="/w/load.php?lang=nl&modules=startup&only=scripts&raw=1&skin=vector-2022"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=nl&modules=site.styles&only=styles&skin=vector-2022"> <meta name="generator" content="MediaWiki 1.44.0-wmf.6"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <meta property="og:title" content="Primaire sleutel - Wikipedia"> <meta property="og:type" content="website"> <link rel="preconnect" href="//upload.wikimedia.org"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//nl.m.wikipedia.org/wiki/Primaire_sleutel"> <link rel="alternate" type="application/x-wiki" title="Bewerken" href="/w/index.php?title=Primaire_sleutel&action=edit"> <link rel="apple-touch-icon" href="/static/apple-touch/wikipedia.png"> <link rel="icon" href="/static/favicon/wikipedia.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="Wikipedia (nl)"> <link rel="EditURI" type="application/rsd+xml" href="//nl.wikipedia.org/w/api.php?action=rsd"> <link rel="canonical" href="https://nl.wikipedia.org/wiki/Primaire_sleutel"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/deed.nl"> <link rel="alternate" type="application/atom+xml" title="Wikipedia Atom-feed" href="/w/index.php?title=Speciaal:RecenteWijzigingen&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="login.wikimedia.org"> </head> <body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject mw-editable page-Primaire_sleutel rootpage-Primaire_sleutel skin-vector-2022 action-view"><a class="mw-jump-link" href="#bodyContent">Naar inhoud springen</a> <div class="vector-header-container"> <header class="vector-header mw-header"> <div class="vector-header-start"> <nav class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-dropdown" class="vector-dropdown vector-main-menu-dropdown vector-button-flush-left vector-button-flush-right" > <input type="checkbox" id="vector-main-menu-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-main-menu-dropdown" class="vector-dropdown-checkbox " aria-label="Hoofdmenu" > <label id="vector-main-menu-dropdown-label" for="vector-main-menu-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-menu mw-ui-icon-wikimedia-menu"></span> <span class="vector-dropdown-label-text">Hoofdmenu</span> </label> <div class="vector-dropdown-content"> <div id="vector-main-menu-unpinned-container" class="vector-unpinned-container"> <div id="vector-main-menu" class="vector-main-menu vector-pinnable-element"> <div class="vector-pinnable-header vector-main-menu-pinnable-header vector-pinnable-header-unpinned" data-feature-name="main-menu-pinned" data-pinnable-element-id="vector-main-menu" data-pinned-container-id="vector-main-menu-pinned-container" data-unpinned-container-id="vector-main-menu-unpinned-container" > <div class="vector-pinnable-header-label">Hoofdmenu</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-main-menu.pin">naar zijbalk verplaatsen</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-main-menu.unpin">verbergen</button> </div> <div id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation" > <div class="vector-menu-heading"> Navigatie </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage" class="mw-list-item"><a href="/wiki/Hoofdpagina" title="Naar de hoofdpagina gaan [z]" accesskey="z"><span>Hoofdpagina</span></a></li><li id="n-zoekartikel" class="mw-list-item"><a href="/wiki/Portaal:Navigatie"><span>Vind een artikel</span></a></li><li id="n-today" class="mw-list-item"><a href="/wiki/11_december"><span>Vandaag</span></a></li><li id="n-Etalage" class="mw-list-item"><a href="/wiki/Wikipedia:Etalage"><span>Etalage</span></a></li><li id="n-categories" class="mw-list-item"><a href="/wiki/Categorie:Alles"><span>Categorieën</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Speciaal:RecenteWijzigingen" title="Een lijst met recente wijzigingen in deze wiki. [r]" accesskey="r"><span>Recente wijzigingen</span></a></li><li id="n-newpages" class="mw-list-item"><a href="/wiki/Speciaal:NieuwePaginas"><span>Nieuwe artikelen</span></a></li><li id="n-randompage" class="mw-list-item"><a href="/wiki/Speciaal:Willekeurig" title="Een willekeurige pagina bekijken [x]" accesskey="x"><span>Willekeurige pagina</span></a></li> </ul> </div> </div> <div id="p-navigation2" class="vector-menu mw-portlet mw-portlet-navigation2" > <div class="vector-menu-heading"> Informatie </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-portal" class="mw-list-item"><a href="/wiki/Portaal:Gebruikersportaal" title="Informatie over het project: wat u kunt doen, waar u dingen kunt vinden"><span>Gebruikersportaal</span></a></li><li id="n-Snelcursus" class="mw-list-item"><a href="/wiki/Wikipedia:Snelcursus"><span>Snelcursus</span></a></li><li id="n-help" class="mw-list-item"><a href="/wiki/Portaal:Hulp_en_beheer" title="Hulpinformatie over deze wiki"><span>Hulp en contact</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> <a href="/wiki/Hoofdpagina" class="mw-logo"> <img class="mw-logo-icon" src="/static/images/icons/wikipedia.png" alt="" aria-hidden="true" height="50" width="50"> <span class="mw-logo-container skin-invert"> <img class="mw-logo-wordmark" alt="Wikipedia" src="/static/images/mobile/copyright/wikipedia-wordmark-en.svg" style="width: 7.5em; height: 1.125em;"> <img class="mw-logo-tagline" alt="de vrije encyclopedie" src="/static/images/mobile/copyright/wikipedia-tagline-nl.svg" width="120" height="13" style="width: 7.5em; height: 0.8125em;"> </span> </a> </div> <div class="vector-header-end"> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-collapses vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"> <a href="/wiki/Speciaal:Zoeken" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only search-toggle" title="Doorzoek Wikipedia [f]" accesskey="f"><span class="vector-icon mw-ui-icon-search mw-ui-icon-wikimedia-search"></span> <span>Zoeken</span> </a> <div class="vector-typeahead-search-container"> <div class="cdx-typeahead-search cdx-typeahead-search--show-thumbnail cdx-typeahead-search--auto-expand-width"> <form action="/w/index.php" id="searchform" class="cdx-search-input cdx-search-input--has-end-button"> <div id="simpleSearch" class="cdx-search-input__input-wrapper" data-search-loc="header-moved"> <div class="cdx-text-input cdx-text-input--has-start-icon"> <input class="cdx-text-input__input" type="search" name="search" placeholder="Doorzoek Wikipedia" aria-label="Doorzoek Wikipedia" autocapitalize="sentences" title="Doorzoek Wikipedia [f]" accesskey="f" id="searchInput" > <span class="cdx-text-input__icon cdx-text-input__start-icon"></span> </div> <input type="hidden" name="title" value="Speciaal:Zoeken"> </div> <button class="cdx-button cdx-search-input__end-button">Zoeken</button> </form> </div> </div> </div> <nav class="vector-user-links vector-user-links-wide" aria-label="Persoonlijke hulpmiddelen"> <div class="vector-user-links-main"> <div id="p-vector-user-menu-preferences" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-userpage" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <nav class="vector-appearance-landmark" aria-label="Uiterlijk"> <div id="vector-appearance-dropdown" class="vector-dropdown " title="De lettergrootte, breedte en kleur van de pagina wijzigen" > <input type="checkbox" id="vector-appearance-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-appearance-dropdown" class="vector-dropdown-checkbox " aria-label="Uiterlijk" > <label id="vector-appearance-dropdown-label" for="vector-appearance-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-appearance mw-ui-icon-wikimedia-appearance"></span> <span class="vector-dropdown-label-text">Uiterlijk</span> </label> <div class="vector-dropdown-content"> <div id="vector-appearance-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <div id="p-vector-user-menu-notifications" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-overflow" class="vector-menu mw-portlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=nl.wikipedia.org&uselang=nl" class=""><span>Doneren</span></a> </li> <li id="pt-createaccount-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Speciaal:GebruikerAanmaken&returnto=Primaire+sleutel" title="Registreer u vooral en meld u aan. Dit is echter niet verplicht." class=""><span>Account aanmaken</span></a> </li> <li id="pt-login-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Speciaal:Aanmelden&returnto=Primaire+sleutel" title="U wordt van harte uitgenodigd om aan te melden, maar dit is niet verplicht [o]" accesskey="o" class=""><span>Aanmelden</span></a> </li> </ul> </div> </div> </div> <div id="vector-user-links-dropdown" class="vector-dropdown vector-user-menu vector-button-flush-right vector-user-menu-logged-out" title="Meer opties" > <input type="checkbox" id="vector-user-links-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-user-links-dropdown" class="vector-dropdown-checkbox " aria-label="Persoonlijke hulpmiddelen" > <label id="vector-user-links-dropdown-label" for="vector-user-links-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-ellipsis mw-ui-icon-wikimedia-ellipsis"></span> <span class="vector-dropdown-label-text">Persoonlijke hulpmiddelen</span> </label> <div class="vector-dropdown-content"> <div id="p-personal" class="vector-menu mw-portlet mw-portlet-personal user-links-collapsible-item" title="Gebruikersmenu" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport" class="user-links-collapsible-item mw-list-item"><a href="https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=nl.wikipedia.org&uselang=nl"><span>Doneren</span></a></li><li id="pt-createaccount" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Speciaal:GebruikerAanmaken&returnto=Primaire+sleutel" title="Registreer u vooral en meld u aan. Dit is echter niet verplicht."><span class="vector-icon mw-ui-icon-userAdd mw-ui-icon-wikimedia-userAdd"></span> <span>Account aanmaken</span></a></li><li id="pt-login" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Speciaal:Aanmelden&returnto=Primaire+sleutel" title="U wordt van harte uitgenodigd om aan te melden, maar dit is niet verplicht [o]" accesskey="o"><span class="vector-icon mw-ui-icon-logIn mw-ui-icon-wikimedia-logIn"></span> <span>Aanmelden</span></a></li> </ul> </div> </div> <div id="p-user-menu-anon-editor" class="vector-menu mw-portlet mw-portlet-user-menu-anon-editor" > <div class="vector-menu-heading"> Pagina's voor uitgelogde redacteuren <a href="/wiki/Help:Inleiding" aria-label="Meer leren over bewerken"><span>meer lezen</span></a> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Speciaal:MijnBijdragen" title="Bijdragen IP-adres [y]" accesskey="y"><span>Bijdragen</span></a></li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Speciaal:MijnOverleg" title="Overlegpagina van de anonieme gebruiker van dit IP-adres [n]" accesskey="n"><span>Overleg</span></a></li> </ul> </div> </div> </div> </div> </nav> </div> </header> </div> <div class="mw-page-container"> <div class="mw-page-container-inner"> <div class="vector-sitenotice-container"> <div id="siteNotice"><!-- CentralNotice --></div> </div> <div class="vector-column-start"> <div class="vector-main-menu-container"> <div id="mw-navigation"> <nav id="mw-panel" class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-pinned-container" class="vector-pinned-container"> </div> </nav> </div> </div> <div class="vector-sticky-pinned-container"> <nav id="mw-panel-toc" aria-label="Inhoud" data-event-name="ui.sidebar-toc" class="mw-table-of-contents-container vector-toc-landmark"> <div id="vector-toc-pinned-container" class="vector-pinned-container"> <div id="vector-toc" class="vector-toc vector-pinnable-element"> <div class="vector-pinnable-header vector-toc-pinnable-header vector-pinnable-header-pinned" data-feature-name="toc-pinned" data-pinnable-element-id="vector-toc" > <h2 class="vector-pinnable-header-label">Inhoud</h2> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-toc.pin">naar zijbalk verplaatsen</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-toc.unpin">verbergen</button> </div> <ul class="vector-toc-contents" id="mw-panel-toc-list"> <li id="toc-mw-content-text" class="vector-toc-list-item vector-toc-level-1"> <a href="#" class="vector-toc-link"> <div class="vector-toc-text">Top</div> </a> </li> <li id="toc-Zie_ook" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Zie_ook"> <div class="vector-toc-text"> <span class="vector-toc-numb">1</span> <span>Zie ook</span> </div> </a> <ul id="toc-Zie_ook-sublist" class="vector-toc-list"> </ul> </li> </ul> </div> </div> </nav> </div> </div> <div class="mw-content-container"> <main id="content" class="mw-body"> <header class="mw-body-header vector-page-titlebar"> <nav aria-label="Inhoud" class="vector-toc-landmark"> <div id="vector-page-titlebar-toc" class="vector-dropdown vector-page-titlebar-toc vector-button-flush-left" > <input type="checkbox" id="vector-page-titlebar-toc-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-titlebar-toc" class="vector-dropdown-checkbox " aria-label="Inhoudsopgave omschakelen" > <label id="vector-page-titlebar-toc-label" for="vector-page-titlebar-toc-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-listBullet mw-ui-icon-wikimedia-listBullet"></span> <span class="vector-dropdown-label-text">Inhoudsopgave omschakelen</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-titlebar-toc-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-main">Primaire sleutel</span></h1> <div id="p-lang-btn" class="vector-dropdown mw-portlet mw-portlet-lang" > <input type="checkbox" id="p-lang-btn-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-lang-btn" class="vector-dropdown-checkbox mw-interlanguage-selector" aria-label="Ga naar een artikel in een andere taal. Beschikbaar in 26 talen" > <label id="p-lang-btn-label" for="p-lang-btn-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--action-progressive mw-portlet-lang-heading-26" aria-hidden="true" ><span class="vector-icon mw-ui-icon-language-progressive mw-ui-icon-wikimedia-language-progressive"></span> <span class="vector-dropdown-label-text">26 talen</span> </label> <div class="vector-dropdown-content"> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="interlanguage-link interwiki-ar mw-list-item"><a href="https://ar.wikipedia.org/wiki/%D9%85%D9%81%D8%AA%D8%A7%D8%AD_%D8%B1%D8%A6%D9%8A%D8%B3%D9%8A" title="مفتاح رئيسي – Arabisch" lang="ar" hreflang="ar" data-title="مفتاح رئيسي" data-language-autonym="العربية" data-language-local-name="Arabisch" class="interlanguage-link-target"><span>العربية</span></a></li><li class="interlanguage-link interwiki-bg mw-list-item"><a href="https://bg.wikipedia.org/wiki/%D0%9F%D1%8A%D1%80%D0%B2%D0%B8%D1%87%D0%B5%D0%BD_%D0%BA%D0%BB%D1%8E%D1%87" title="Първичен ключ – Bulgaars" lang="bg" hreflang="bg" data-title="Първичен ключ" data-language-autonym="Български" data-language-local-name="Bulgaars" class="interlanguage-link-target"><span>Български</span></a></li><li class="interlanguage-link interwiki-ca mw-list-item"><a href="https://ca.wikipedia.org/wiki/Clau_prim%C3%A0ria" title="Clau primària – Catalaans" lang="ca" hreflang="ca" data-title="Clau primària" data-language-autonym="Català" data-language-local-name="Catalaans" class="interlanguage-link-target"><span>Català</span></a></li><li class="interlanguage-link interwiki-cs mw-list-item"><a href="https://cs.wikipedia.org/wiki/Prim%C3%A1rn%C3%AD_kl%C3%AD%C4%8D" title="Primární klíč – Tsjechisch" lang="cs" hreflang="cs" data-title="Primární klíč" data-language-autonym="Čeština" data-language-local-name="Tsjechisch" class="interlanguage-link-target"><span>Čeština</span></a></li><li class="interlanguage-link interwiki-de badge-Q70894304 mw-list-item" title=""><a href="https://de.wikipedia.org/wiki/Prim%C3%A4rschl%C3%BCssel" title="Primärschlüssel – Duits" lang="de" hreflang="de" data-title="Primärschlüssel" data-language-autonym="Deutsch" data-language-local-name="Duits" class="interlanguage-link-target"><span>Deutsch</span></a></li><li class="interlanguage-link interwiki-en mw-list-item"><a href="https://en.wikipedia.org/wiki/Primary_key" title="Primary key – Engels" lang="en" hreflang="en" data-title="Primary key" data-language-autonym="English" data-language-local-name="Engels" class="interlanguage-link-target"><span>English</span></a></li><li class="interlanguage-link interwiki-es mw-list-item"><a href="https://es.wikipedia.org/wiki/Clave_primaria" title="Clave primaria – Spaans" lang="es" hreflang="es" data-title="Clave primaria" data-language-autonym="Español" data-language-local-name="Spaans" class="interlanguage-link-target"><span>Español</span></a></li><li class="interlanguage-link interwiki-fa mw-list-item"><a href="https://fa.wikipedia.org/wiki/%DA%A9%D9%84%DB%8C%D8%AF_%D8%A7%D8%B5%D9%84%DB%8C" title="کلید اصلی – Perzisch" lang="fa" hreflang="fa" data-title="کلید اصلی" data-language-autonym="فارسی" data-language-local-name="Perzisch" class="interlanguage-link-target"><span>فارسی</span></a></li><li class="interlanguage-link interwiki-fr mw-list-item"><a href="https://fr.wikipedia.org/wiki/Cl%C3%A9_primaire" title="Clé primaire – Frans" lang="fr" hreflang="fr" data-title="Clé primaire" data-language-autonym="Français" data-language-local-name="Frans" class="interlanguage-link-target"><span>Français</span></a></li><li class="interlanguage-link interwiki-he mw-list-item"><a href="https://he.wikipedia.org/wiki/%D7%9E%D7%A4%D7%AA%D7%97_%D7%A8%D7%90%D7%A9%D7%99" title="מפתח ראשי – Hebreeuws" lang="he" hreflang="he" data-title="מפתח ראשי" data-language-autonym="עברית" data-language-local-name="Hebreeuws" class="interlanguage-link-target"><span>עברית</span></a></li><li class="interlanguage-link interwiki-id mw-list-item"><a href="https://id.wikipedia.org/wiki/Kunci_primer" title="Kunci primer – Indonesisch" lang="id" hreflang="id" data-title="Kunci primer" data-language-autonym="Bahasa Indonesia" data-language-local-name="Indonesisch" class="interlanguage-link-target"><span>Bahasa Indonesia</span></a></li><li class="interlanguage-link interwiki-it mw-list-item"><a href="https://it.wikipedia.org/wiki/Chiave_primaria" title="Chiave primaria – Italiaans" lang="it" hreflang="it" data-title="Chiave primaria" data-language-autonym="Italiano" data-language-local-name="Italiaans" class="interlanguage-link-target"><span>Italiano</span></a></li><li class="interlanguage-link interwiki-ja mw-list-item"><a href="https://ja.wikipedia.org/wiki/%E4%B8%BB%E3%82%AD%E3%83%BC" title="主キー – Japans" lang="ja" hreflang="ja" data-title="主キー" data-language-autonym="日本語" data-language-local-name="Japans" class="interlanguage-link-target"><span>日本語</span></a></li><li class="interlanguage-link interwiki-kk mw-list-item"><a href="https://kk.wikipedia.org/wiki/%D0%9D%D0%B5%D0%B3%D1%96%D0%B7%D0%B3%D1%96_%D0%BA%D1%96%D0%BB%D1%82" title="Негізгі кілт – Kazachs" lang="kk" hreflang="kk" data-title="Негізгі кілт" data-language-autonym="Қазақша" data-language-local-name="Kazachs" class="interlanguage-link-target"><span>Қазақша</span></a></li><li class="interlanguage-link interwiki-ko mw-list-item"><a href="https://ko.wikipedia.org/wiki/%EA%B8%B0%EB%B3%B8_%ED%82%A4" title="기본 키 – Koreaans" lang="ko" hreflang="ko" data-title="기본 키" data-language-autonym="한국어" data-language-local-name="Koreaans" class="interlanguage-link-target"><span>한국어</span></a></li><li class="interlanguage-link interwiki-ms mw-list-item"><a href="https://ms.wikipedia.org/wiki/Kekunci_primer" title="Kekunci primer – Maleis" lang="ms" hreflang="ms" data-title="Kekunci primer" data-language-autonym="Bahasa Melayu" data-language-local-name="Maleis" class="interlanguage-link-target"><span>Bahasa Melayu</span></a></li><li class="interlanguage-link interwiki-pl mw-list-item"><a href="https://pl.wikipedia.org/wiki/Klucz_g%C5%82%C3%B3wny" title="Klucz główny – Pools" lang="pl" hreflang="pl" data-title="Klucz główny" data-language-autonym="Polski" data-language-local-name="Pools" class="interlanguage-link-target"><span>Polski</span></a></li><li class="interlanguage-link interwiki-pt mw-list-item"><a href="https://pt.wikipedia.org/wiki/Chave_prim%C3%A1ria" title="Chave primária – Portugees" lang="pt" hreflang="pt" data-title="Chave primária" data-language-autonym="Português" data-language-local-name="Portugees" class="interlanguage-link-target"><span>Português</span></a></li><li class="interlanguage-link interwiki-ru mw-list-item"><a href="https://ru.wikipedia.org/wiki/%D0%9F%D0%B5%D1%80%D0%B2%D0%B8%D1%87%D0%BD%D1%8B%D0%B9_%D0%BA%D0%BB%D1%8E%D1%87" title="Первичный ключ – Russisch" lang="ru" hreflang="ru" data-title="Первичный ключ" data-language-autonym="Русский" data-language-local-name="Russisch" class="interlanguage-link-target"><span>Русский</span></a></li><li class="interlanguage-link interwiki-sk mw-list-item"><a href="https://sk.wikipedia.org/wiki/Prim%C3%A1rny_k%C4%BE%C3%BA%C4%8D" title="Primárny kľúč – Slowaaks" lang="sk" hreflang="sk" data-title="Primárny kľúč" data-language-autonym="Slovenčina" data-language-local-name="Slowaaks" class="interlanguage-link-target"><span>Slovenčina</span></a></li><li class="interlanguage-link interwiki-sq mw-list-item"><a href="https://sq.wikipedia.org/wiki/%C3%87el%C3%ABsi_par%C3%ABsor" title="Çelësi parësor – Albanees" lang="sq" hreflang="sq" data-title="Çelësi parësor" data-language-autonym="Shqip" data-language-local-name="Albanees" class="interlanguage-link-target"><span>Shqip</span></a></li><li class="interlanguage-link interwiki-sr mw-list-item"><a href="https://sr.wikipedia.org/wiki/%D0%9F%D1%80%D0%B8%D0%BC%D0%B0%D1%80%D0%BD%D0%B8_%D0%BA%D1%99%D1%83%D1%87" title="Примарни кључ – Servisch" lang="sr" hreflang="sr" data-title="Примарни кључ" data-language-autonym="Српски / srpski" data-language-local-name="Servisch" class="interlanguage-link-target"><span>Српски / srpski</span></a></li><li class="interlanguage-link interwiki-uk mw-list-item"><a href="https://uk.wikipedia.org/wiki/%D0%9F%D0%B5%D1%80%D0%B2%D0%B8%D0%BD%D0%BD%D0%B8%D0%B9_%D0%BA%D0%BB%D1%8E%D1%87" title="Первинний ключ – Oekraïens" lang="uk" hreflang="uk" data-title="Первинний ключ" data-language-autonym="Українська" data-language-local-name="Oekraïens" class="interlanguage-link-target"><span>Українська</span></a></li><li class="interlanguage-link interwiki-vi mw-list-item"><a href="https://vi.wikipedia.org/wiki/Kh%C3%B3a_ch%C3%ADnh" title="Khóa chính – Vietnamees" lang="vi" hreflang="vi" data-title="Khóa chính" data-language-autonym="Tiếng Việt" data-language-local-name="Vietnamees" class="interlanguage-link-target"><span>Tiếng Việt</span></a></li><li class="interlanguage-link interwiki-zh mw-list-item"><a href="https://zh.wikipedia.org/wiki/%E5%85%B3%E7%B3%BB%E9%94%AE" title="关系键 – Chinees" lang="zh" hreflang="zh" data-title="关系键" data-language-autonym="中文" data-language-local-name="Chinees" class="interlanguage-link-target"><span>中文</span></a></li><li class="interlanguage-link interwiki-zh-yue mw-list-item"><a href="https://zh-yue.wikipedia.org/wiki/%E4%B8%BB%E5%8C%99" title="主匙 – Kantonees" lang="yue" hreflang="yue" data-title="主匙" data-language-autonym="粵語" data-language-local-name="Kantonees" class="interlanguage-link-target"><span>粵語</span></a></li> </ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-edit wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q934729#sitelinks-wikipedia" title="Taalkoppelingen bewerken" class="wbc-editpage">Koppelingen bewerken</a></span></div> </div> </div> </div> </header> <div class="vector-page-toolbar"> <div class="vector-page-toolbar-container"> <div id="left-navigation"> <nav aria-label="Naamruimten"> <div id="p-associated-pages" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-associated-pages" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-main" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Primaire_sleutel" title="Inhoudspagina bekijken [c]" accesskey="c"><span>Artikel</span></a></li><li id="ca-talk" class="new vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Overleg:Primaire_sleutel&action=edit&redlink=1" rel="discussion" class="new" title="Overleg over deze pagina (de pagina bestaat niet) [t]" accesskey="t"><span>Overleg</span></a></li> </ul> </div> </div> <div id="vector-variants-dropdown" class="vector-dropdown emptyPortlet" > <input type="checkbox" id="vector-variants-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-variants-dropdown" class="vector-dropdown-checkbox " aria-label="Taalvariant wijzigen" > <label id="vector-variants-dropdown-label" for="vector-variants-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">Nederlands</span> </label> <div class="vector-dropdown-content"> <div id="p-variants" class="vector-menu mw-portlet mw-portlet-variants emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> </div> </div> </nav> </div> <div id="right-navigation" class="vector-collapsible"> <nav aria-label="Weergaven"> <div id="p-views" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-views" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Primaire_sleutel"><span>Lezen</span></a></li><li id="ca-ve-edit" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Primaire_sleutel&veaction=edit" title="Deze pagina bewerken [v]" accesskey="v"><span>Bewerken</span></a></li><li id="ca-edit" class="collapsible vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Primaire_sleutel&action=edit" title="Broncode van deze pagina bewerken [e]" accesskey="e"><span>Brontekst bewerken</span></a></li><li id="ca-history" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Primaire_sleutel&action=history" title="Eerdere versies van deze pagina [h]" accesskey="h"><span>Geschiedenis weergeven</span></a></li> </ul> </div> </div> </nav> <nav class="vector-page-tools-landmark" aria-label="Paginahulpmiddelen"> <div id="vector-page-tools-dropdown" class="vector-dropdown vector-page-tools-dropdown" > <input type="checkbox" id="vector-page-tools-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-tools-dropdown" class="vector-dropdown-checkbox " aria-label="Hulpmiddelen" > <label id="vector-page-tools-dropdown-label" for="vector-page-tools-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">Hulpmiddelen</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-tools-unpinned-container" class="vector-unpinned-container"> <div id="vector-page-tools" class="vector-page-tools vector-pinnable-element"> <div class="vector-pinnable-header vector-page-tools-pinnable-header vector-pinnable-header-unpinned" data-feature-name="page-tools-pinned" data-pinnable-element-id="vector-page-tools" data-pinned-container-id="vector-page-tools-pinned-container" data-unpinned-container-id="vector-page-tools-unpinned-container" > <div class="vector-pinnable-header-label">Hulpmiddelen</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-page-tools.pin">naar zijbalk verplaatsen</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-page-tools.unpin">verbergen</button> </div> <div id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-has-collapsible-items" title="Meer opties" > <div class="vector-menu-heading"> Handelingen </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-more-view" class="selected vector-more-collapsible-item mw-list-item"><a href="/wiki/Primaire_sleutel"><span>Lezen</span></a></li><li id="ca-more-ve-edit" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Primaire_sleutel&veaction=edit" title="Deze pagina bewerken [v]" accesskey="v"><span>Bewerken</span></a></li><li id="ca-more-edit" class="collapsible vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Primaire_sleutel&action=edit" title="Broncode van deze pagina bewerken [e]" accesskey="e"><span>Brontekst bewerken</span></a></li><li id="ca-more-history" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Primaire_sleutel&action=history"><span>Geschiedenis weergeven</span></a></li> </ul> </div> </div> <div id="p-tb" class="vector-menu mw-portlet mw-portlet-tb" > <div class="vector-menu-heading"> Algemeen </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Speciaal:VerwijzingenNaarHier/Primaire_sleutel" title="Lijst met alle pagina's die naar deze pagina verwijzen [j]" accesskey="j"><span>Links naar deze pagina</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Speciaal:RecenteWijzigingenGelinkt/Primaire_sleutel" rel="nofollow" title="Recente wijzigingen in pagina's waar deze pagina naar verwijst [k]" accesskey="k"><span>Gerelateerde wijzigingen</span></a></li><li id="t-upload" class="mw-list-item"><a href="//commons.wikimedia.org/wiki/Special:UploadWizard?uselang=nl" title="Bestanden uploaden [u]" accesskey="u"><span>Bestand uploaden</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Speciaal:SpecialePaginas" title="Lijst met alle speciale pagina's [q]" accesskey="q"><span>Speciale pagina's</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Primaire_sleutel&oldid=53813117" title="Permanente koppeling naar deze versie van deze pagina"><span>Permanente koppeling</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Primaire_sleutel&action=info" title="Meer informatie over deze pagina"><span>Paginagegevens</span></a></li><li id="t-cite" class="mw-list-item"><a href="/w/index.php?title=Speciaal:Citeren&page=Primaire_sleutel&id=53813117&wpFormIdentifier=titleform" title="Informatie over hoe u deze pagina kunt citeren"><span>Deze pagina citeren</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Speciaal:UrlQ%C4%B1sald%C4%B1c%C4%B1s%C4%B1&url=https%3A%2F%2Fnl.wikipedia.org%2Fwiki%2FPrimaire_sleutel"><span>Verkorte URL verkrijgen</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Speciaal:QrKodu&url=https%3A%2F%2Fnl.wikipedia.org%2Fwiki%2FPrimaire_sleutel"><span>QR-code downloaden</span></a></li> </ul> </div> </div> <div id="p-coll-print_export" class="vector-menu mw-portlet mw-portlet-coll-print_export" > <div class="vector-menu-heading"> Afdrukken/exporteren </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-create_a_book" class="mw-list-item"><a href="/w/index.php?title=Speciaal:Boek&bookcmd=book_creator&referer=Primaire+sleutel"><span>Boek aanmaken</span></a></li><li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Speciaal:DownloadAsPdf&page=Primaire_sleutel&action=show-download-screen"><span>Downloaden als PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=Primaire_sleutel&printable=yes" title="Printvriendelijke versie van deze pagina [p]" accesskey="p"><span>Afdrukversie</span></a></li> </ul> </div> </div> <div id="p-wikibase-otherprojects" class="vector-menu mw-portlet mw-portlet-wikibase-otherprojects" > <div class="vector-menu-heading"> In andere projecten </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q934729" title="Koppeling naar item in verbonden gegevensrepository [g]" accesskey="g"><span>Wikidata-item</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> </div> </div> </div> <div class="vector-column-end"> <div class="vector-sticky-pinned-container"> <nav class="vector-page-tools-landmark" aria-label="Paginahulpmiddelen"> <div id="vector-page-tools-pinned-container" class="vector-pinned-container"> </div> </nav> <nav class="vector-appearance-landmark" aria-label="Uiterlijk"> <div id="vector-appearance-pinned-container" class="vector-pinned-container"> <div id="vector-appearance" class="vector-appearance vector-pinnable-element"> <div class="vector-pinnable-header vector-appearance-pinnable-header vector-pinnable-header-pinned" data-feature-name="appearance-pinned" data-pinnable-element-id="vector-appearance" data-pinned-container-id="vector-appearance-pinned-container" data-unpinned-container-id="vector-appearance-unpinned-container" > <div class="vector-pinnable-header-label">Uiterlijk</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-appearance.pin">naar zijbalk verplaatsen</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-appearance.unpin">verbergen</button> </div> </div> </div> </nav> </div> </div> <div id="bodyContent" class="vector-body" aria-labelledby="firstHeading" data-mw-ve-target-container> <div class="vector-body-before-content"> <div class="mw-indicators"> </div> <div id="siteSub" class="noprint">Uit Wikipedia, de vrije encyclopedie</div> </div> <div id="contentSub"><div id="mw-content-subtitle"></div></div> <div id="mw-content-text" class="mw-body-content"><div class="mw-content-ltr mw-parser-output" lang="nl" dir="ltr"><p><b>Primaire sleutel</b> is in <a href="/wiki/Database" title="Database">databasetechnologie</a> de benaming voor een <a href="/wiki/Attribuut_(informatica)" title="Attribuut (informatica)">attribuut</a>, eigenschap, karakteristiek of feit (of een combinatie hiervan) over een entiteit, fysiek object of gebeurtenis die voldoet aan volgende vier eisen: </p> <ol><li><i><a href="/wiki/Uniciteit" title="Uniciteit">Uniekheid</a></i>: de waarde van het attribuut (of een combinatie hiervan) is uniek binnen de tabel en bepaalt dus eenduidig de record, rij of tupel waarin dit attribuut voorkomt. Geen twee rijen in een tabel kunnen dus identiek zijn vanwege het unieke attribuut (of combinatie van) in iedere rij.</li> <li><i>Niet leeg</i>: het attribuut (of een combinatie hiervan) is overal ingevuld. Kan dus niet leeg zijn.</li> <li><i>Minimaal aantal attributen</i>: de combinatie van attributen is minimaal. Door het laten vallen van een van de attributen wordt het record, rij of tupel niet langer meer eenduidig bepaald.</li> <li><i>Legt relatie tussen tabellen</i>: wanneer gerelateerde tabellen verwijzen naar de tabel waarin het attribuut (of een combinatie hiervan) voorkomt, wordt deze gebruikt om een relatie tussen deze tabellen tot stand te brengen.</li></ol> <p>Daar voorwaarde 1, 2 en 3 de voorwaarden zijn om te kunnen spreken van een <a href="/wiki/Kandidaatsleutel" title="Kandidaatsleutel">kandidaatsleutel</a>, kan een primaire sleutel ook worden omschreven als: </p> <ul><li><i>De kandidaatsleutel die wordt gebruikt als unieke identificatiemethode van een record, rij of tupel binnen een tabel.</i></li></ul> <div class="mw-heading mw-heading2"><h2 id="Zie_ook">Zie ook</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Primaire_sleutel&veaction=edit&section=1" title="Bewerk dit kopje: Zie ook" class="mw-editsection-visualeditor"><span>bewerken</span></a><span class="mw-editsection-divider"> | </span><a href="/w/index.php?title=Primaire_sleutel&action=edit&section=1" title="De broncode bewerken van de sectie: Zie ook"><span>brontekst bewerken</span></a><span class="mw-editsection-bracket">]</span></span></div> <ul><li><a href="/wiki/Databasenormalisatie" title="Databasenormalisatie">Databasenormalisatie</a></li></ul> <style data-mw-deduplicate="TemplateStyles:r67837862">.mw-parser-output .navigatie{position:relative;clear:both;overflow:auto;margin:1em auto -0.5em;padding:2px;background-color:var(--background-color-neutral-subtle,#f8f9fa);border:1px solid var(--border-color-base,#a2a9b1);text-align:center;font-size:87%}.mw-parser-output .navigatie-bewerken{margin-left:0.5em}.mw-parser-output .navigatie-bewerken .mw-ui-icon::before{background-size:0.9em}.mw-parser-output .navigatie-afb-links,.mw-parser-output .navigatie-afb-rechts{position:absolute}.mw-parser-output .navigatie-afb-rechts{right:2px}.mw-parser-output .navigatie-afb-groot{float:right;padding-left:0.5em}.mw-parser-output .navigatie-titel{background-color:#ddeef8;padding:2px 5.5em;font-weight:bold}.mw-parser-output .navigatie-inhoud{padding:0.5em}.mw-parser-output .navigatie-inhoud p:first-child{margin:0}.mw-parser-output .navigatie div[style*="background-color"],.mw-parser-output .navigatie div[style*="background"]{color:inherit}@media screen{html.skin-theme-clientpref-night .mw-parser-output .navigatie-titel{background-color:var(--background-color-interactive,#eaecf0)!important}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .navigatie-titel{background-color:var(--background-color-interactive,#eaecf0)!important}}</style> <div class="navigatie" role="navigation" aria-labelledby="Databases"> <div class="navigatie-afb-links noviewer"><div class="navigatie-bewerken show-autoconfirmed nomobile"><span class="nowrap skin-invert-image"><span typeof="mw:File"><a href="/wiki/Sjabloon:Navigatie_databases" title="Sjabloon:Navigatie databases"><img src="//upload.wikimedia.org/wikipedia/commons/thumb/c/c4/OOjs_UI_icon_article-ltr.svg/16px-OOjs_UI_icon_article-ltr.svg.png" decoding="async" width="16" height="16" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/c/c4/OOjs_UI_icon_article-ltr.svg/24px-OOjs_UI_icon_article-ltr.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/c/c4/OOjs_UI_icon_article-ltr.svg/32px-OOjs_UI_icon_article-ltr.svg.png 2x" data-file-width="20" data-file-height="20" /></a></span> · <span typeof="mw:File"><a href="https://en.wikipedia.org/wiki/nl:Overleg_sjabloon:Navigatie_databases" title="Overleg sjabloon"><img alt="Overleg sjabloon" src="//upload.wikimedia.org/wikipedia/commons/thumb/4/40/OOjs_UI_icon_speechBubbles-ltr.svg/16px-OOjs_UI_icon_speechBubbles-ltr.svg.png" decoding="async" width="16" height="16" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/4/40/OOjs_UI_icon_speechBubbles-ltr.svg/24px-OOjs_UI_icon_speechBubbles-ltr.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/4/40/OOjs_UI_icon_speechBubbles-ltr.svg/32px-OOjs_UI_icon_speechBubbles-ltr.svg.png 2x" data-file-width="20" data-file-height="20" /></a></span> · <span typeof="mw:File"><a href="//nl.wikipedia.org/w/index.php?title=Sjabloon:Navigatie_databases&action=edit" title="Sjabloon bewerken"><img alt="Sjabloon bewerken" src="//upload.wikimedia.org/wikipedia/commons/thumb/8/8a/OOjs_UI_icon_edit-ltr.svg/16px-OOjs_UI_icon_edit-ltr.svg.png" decoding="async" width="16" height="16" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/8/8a/OOjs_UI_icon_edit-ltr.svg/24px-OOjs_UI_icon_edit-ltr.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/8/8a/OOjs_UI_icon_edit-ltr.svg/32px-OOjs_UI_icon_edit-ltr.svg.png 2x" data-file-width="20" data-file-height="20" /></a></span></span></div></div> <div id="Databases" class="navigatie-titel">Databases</div> <div class="navigatie-inhoud"> <p><a href="/wiki/Databasemanagementsysteem" title="Databasemanagementsysteem">databasemanagementsysteem</a> · <a href="/wiki/Databasemodel" title="Databasemodel">databasemodel</a> · <a href="/wiki/Databasenormalisatie" title="Databasenormalisatie">databasenormalisatie</a> · <a href="/wiki/Referenti%C3%ABle_integriteit" title="Referentiële integriteit">referentiële integriteit</a> · <a href="/wiki/Relationele_algebra" title="Relationele algebra">relationele algebra</a> · <a href="/wiki/Relationele_database" title="Relationele database">relationele database</a> · <a href="/wiki/Relationeel_model" title="Relationeel model">relationeel model</a> </p> <style data-mw-deduplicate="TemplateStyles:r67785531">.mw-parser-output .navigatie-tabel{margin:0 auto 0 auto;text-align:left}.mw-parser-output .navigatie-tabel .links{text-align:right}.mw-parser-output .navigatie-tabel .rechts{padding-left:0.5em}@media screen and (max-width:640px){.mw-parser-output .navigatie-tabel tr{display:grid;grid-template-columns:1fr;width:100%;margin-bottom:0.5em}.mw-parser-output .navigatie-tabel tr:last-of-type{margin-bottom:0}.mw-parser-output .navigatie-tabel .links{text-align:unset}.mw-parser-output .navigatie-tabel .rechts{padding:unset}}</style><table class="navigatie-tabel vatop" cellpadding="0" cellspacing="0" style=""><tbody><tr><td class="links" style=""><b>Begrippen:</b></td><td class="rechts"><a href="/wiki/Database" title="Database">database</a> · <a href="/wiki/ACID" title="ACID">ACID</a> · <a href="/wiki/CRUD" title="CRUD">CRUD</a> · <a href="/wiki/Null" title="Null">null</a> · <a href="/wiki/Vreemde_sleutel" title="Vreemde sleutel">vreemde sleutel</a> · <a class="mw-selflink selflink">primaire sleutel</a> · <a href="/wiki/Kandidaatsleutel" title="Kandidaatsleutel">kandidaatsleutel</a> · <a href="/w/index.php?title=Axioma%27s_van_Armstrong&action=edit&redlink=1" class="new" title="Axioma's van Armstrong (de pagina bestaat niet)">axioma's van Armstrong</a></td></tr><tr><td class="links"><b>Objecten:</b></td><td class="rechts"><a href="/wiki/Tabel_(database)" title="Tabel (database)">tabel</a> · <a href="/wiki/Relatie" title="Relatie">relatie</a> · <a href="/w/index.php?title=View_(database)&action=edit&redlink=1" class="new" title="View (database) (de pagina bestaat niet)">view</a> · <a href="/wiki/Transactie_(dataopslag)" title="Transactie (dataopslag)">transactie</a> · <a href="/wiki/Trigger" title="Trigger">trigger</a> · <a href="/wiki/Index_(database)" title="Index (database)">index</a> · <a href="/wiki/Opgeslagen_procedure" title="Opgeslagen procedure">opgeslagen procedure</a> · <a href="/wiki/Cursor" title="Cursor">cursor</a> · <a href="/w/index.php?title=Partitie_(database)&action=edit&redlink=1" class="new" title="Partitie (database) (de pagina bestaat niet)">partitie</a></td></tr><tr><td class="links"><b><a href="/wiki/SQL" title="SQL">SQL</a>:</b></td><td class="rechts"><a href="/wiki/Select_(SQL)" title="Select (SQL)">Select</a> · <a href="/wiki/Insert_(SQL)" title="Insert (SQL)">Insert</a> · <a href="/wiki/Update_(SQL)" title="Update (SQL)">Update</a> · <a href="/wiki/Merge_(SQL)" title="Merge (SQL)">Merge</a> · <a href="/wiki/Delete_(SQL)" title="Delete (SQL)">Delete</a> · <a href="/wiki/From_(SQL)" title="From (SQL)">From</a> · <a href="/wiki/Join_(SQL)" title="Join (SQL)">Join</a> · <a href="/wiki/Union_(SQL)" title="Union (SQL)">Union</a> · <a href="/wiki/Create_(SQL)" title="Create (SQL)">Create</a> · <a href="/wiki/Drop_(SQL)" title="Drop (SQL)">Drop</a> · <a href="/wiki/Commit" title="Commit">Commit</a> · <a href="/wiki/Rollback_(dataopslag)" title="Rollback (dataopslag)">Rollback</a> · <a href="/wiki/Truncate_(SQL)" title="Truncate (SQL)">Truncate</a> · <a href="/wiki/Alter_(SQL)" title="Alter (SQL)">Alter</a> · <a href="/wiki/Where_(SQL)" title="Where (SQL)">Where</a> · <a href="/wiki/Data_definition_language" title="Data definition language">DDL</a> · <a href="/wiki/Data_manipulation_language" title="Data manipulation language">DML</a> · <a href="/wiki/Data_control_language" title="Data control language">DCL</a></td></tr><tr><td class="links"><b>Producten:</b></td><td class="rechts"><a href="/wiki/Lijst_van_relationele_databases" title="Lijst van relationele databases">relationele databases</a></td></tr></tbody></table> </div></div> <!-- NewPP limit report Parsed by mw‐web.eqiad.main‐745f94f9f8‐6fmqc Cached time: 20241119223410 Cache expiry: 2592000 Reduced expiry: false Complications: [] CPU time usage: 0.052 seconds Real time usage: 0.067 seconds Preprocessor visited node count: 316/1000000 Post‐expand include size: 9043/2097152 bytes Template argument size: 3655/2097152 bytes Highest expansion depth: 10/100 Expensive parser function count: 1/500 Unstrip recursion depth: 0/20 Unstrip post‐expand size: 2004/5000000 bytes Number of Wikibase entities loaded: 0/400 --> <!-- Transclusion expansion time report (%,ms,calls,template) 100.00% 44.753 1 Sjabloon:Navigatie_databases 100.00% 44.753 1 -total 91.86% 41.110 1 Sjabloon:Navigatie 32.90% 14.724 1 Sjabloon:Navigatie/Tabel 8.95% 4.006 1 Sjabloon:Bewerklinks --> <!-- Saved in parser cache with key nlwiki:pcache:299523:|#|:idhash:canonical and timestamp 20241119223410 and revision id 53813117. Rendering was triggered because: page-view --> </div><!--esi <esi:include src="/esitest-fa8a495983347898/content" /> --><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?useformat=desktop&type=1x1&usesul3=0" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Overgenomen van "<a dir="ltr" href="https://nl.wikipedia.org/w/index.php?title=Primaire_sleutel&oldid=53813117">https://nl.wikipedia.org/w/index.php?title=Primaire_sleutel&oldid=53813117</a>"</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/wiki/Categorie:Alles" title="Categorie:Alles">Categorieën</a>: <ul><li><a href="/wiki/Categorie:Database" title="Categorie:Database">Database</a></li><li><a href="/wiki/Categorie:Dataopslag" title="Categorie:Dataopslag">Dataopslag</a></li></ul></div></div> </div> </main> </div> <div class="mw-footer-container"> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> Deze pagina is voor het laatst bewerkt op 12 mei 2019 om 20:33.</li> <li id="footer-info-copyright">De tekst is beschikbaar onder de licentie <a rel="nofollow" class="external text" href="//creativecommons.org/licenses/by-sa/4.0/deed.nl">Creative Commons Naamsvermelding/Gelijk delen</a>, er kunnen aanvullende voorwaarden van toepassing zijn. Zie de <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use/nl">gebruiksvoorwaarden</a> voor meer informatie.<br /> Wikipedia® is een geregistreerd handelsmerk van de <a rel="nofollow" class="external text" href="https://www.wikimediafoundation.org">Wikimedia Foundation, Inc.</a>, een organisatie zonder winstoogmerk.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacybeleid</a></li> <li id="footer-places-about"><a href="/wiki/Wikipedia">Over Wikipedia</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Wikipedia:Algemeen_voorbehoud">Disclaimers</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Universal_Code_of_Conduct">Gedragscode</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Ontwikkelaars</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/nl.wikipedia.org">Statistieken</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookieverklaring</a></li> <li id="footer-places-mobileview"><a href="//nl.m.wikipedia.org/w/index.php?title=Primaire_sleutel&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobiele weergave</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> </div> </div> </div> <div class="vector-settings" id="p-dock-bottom"> <ul></ul> </div><script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgHostname":"mw-web.codfw.main-7bbfc6c4f5-qmwhr","wgBackendResponseTime":134,"wgPageParseReport":{"limitreport":{"cputime":"0.052","walltime":"0.067","ppvisitednodes":{"value":316,"limit":1000000},"postexpandincludesize":{"value":9043,"limit":2097152},"templateargumentsize":{"value":3655,"limit":2097152},"expansiondepth":{"value":10,"limit":100},"expensivefunctioncount":{"value":1,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":2004,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 44.753 1 Sjabloon:Navigatie_databases","100.00% 44.753 1 -total"," 91.86% 41.110 1 Sjabloon:Navigatie"," 32.90% 14.724 1 Sjabloon:Navigatie/Tabel"," 8.95% 4.006 1 Sjabloon:Bewerklinks"]},"cachereport":{"origin":"mw-web.eqiad.main-745f94f9f8-6fmqc","timestamp":"20241119223410","ttl":2592000,"transientcontent":false}}});});</script> <script type="application/ld+json">{"@context":"https:\/\/schema.org","@type":"Article","name":"Primaire sleutel","url":"https:\/\/nl.wikipedia.org\/wiki\/Primaire_sleutel","sameAs":"http:\/\/www.wikidata.org\/entity\/Q934729","mainEntity":"http:\/\/www.wikidata.org\/entity\/Q934729","author":{"@type":"Organization","name":"Bijdragers aan Wikimedia-projecten"},"publisher":{"@type":"Organization","name":"Wikimedia Foundation, Inc.","logo":{"@type":"ImageObject","url":"https:\/\/www.wikimedia.org\/static\/images\/wmf-hor-googpub.png"}},"datePublished":"2005-11-15T08:48:55Z","dateModified":"2019-05-12T19:33:37Z"}</script> </body> </html>