{"id":8949,"date":"2023-08-07T06:15:00","date_gmt":"2023-08-07T04:15:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=8949"},"modified":"2023-10-24T14:29:05","modified_gmt":"2023-10-24T12:29:05","slug":"creer-table-sql-server-cle-primaire","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/","title":{"rendered":"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><strong><em>Comment cr\u00e9er une table SQL Server avec une contrainte de cl\u00e9 primaire pour \u00e9viter les donn\u00e9es en double ?<\/em><\/strong><\/h4>\n\n\n\n<p>Tutoriel pour cr\u00e9er une table SQL Server avec une cl\u00e9 primaire pour identifier une ligne de donn\u00e9es par une valeur unique, c&rsquo;est donc une clef unique. Cette clef est identifi\u00e9e sur une ou plusieurs colonnes. Tout d&rsquo;abord, quel est l&rsquo;objectif d&rsquo;une cl\u00e9 primaire ? Et surtout, quelle est la d\u00e9finition d&rsquo;une cl\u00e9 primaire ? Une cl\u00e9 primaire garantit qu&rsquo;une seule ligne unique correspond \u00e0 un identifiant sp\u00e9cifique.<\/p>\n\n\n\n<p>Pour cr\u00e9er une table et lui ajouter une contrainte de cl\u00e9 primaire, suivre ces quatre \u00e9tapes :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Premi\u00e8rement, concevoir la table des clients \u00e0 l&rsquo;aide du code SQL.<\/li>\n\n\n\n<li>Deuxi\u00e8mement, ajouter une contrainte sur la colonne s\u00e9lectionn\u00e9e pour \u00eatre la cl\u00e9.<\/li>\n\n\n\n<li>Ins\u00e9rer deux lignes avec le m\u00eame ID client.<\/li>\n\n\n\n<li>V\u00e9rifier le r\u00e9sultat des donn\u00e9es dans la table.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-creer-une-table-de-clients-avec-une-colonne-id\">1. Cr\u00e9er une table de clients avec une colonne ID<\/h2>\n\n\n\n<p>Cr\u00e9ez une table clients avec un ID client.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Cr\u00e9er la table des clients avec la colonne CustomerID d\u00e9clar\u00e9e comme NOT NULL\nCREATE TABLE dbo.Customers (\n\t[CustomerID]\tINT NOT NULL,\n\t[FirstName] \tNVARCHAR(20),\n\t[LastName]  \tNVARCHAR(20),\n\t[City]      \tNVARCHAR(20),\n\t[Country]   \tNVARCHAR(50)\n)\nGO<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-ajouter-une-contrainte-de-clef-primaire-a-une-colonne\">2. Ajouter une contrainte de clef primaire \u00e0 une colonne<\/h2>\n\n\n\n<p>Ici la contrainte de cl\u00e9 primaire est bas\u00e9e sur la colonne <em>CustomerID<\/em>, c&rsquo;est  dire le num\u00e9ro de client. Utiliser la commande T-SQL <em>ADD CONSTRAINT PRIMARY KEY<\/em> pour ajouter la contrainte. Voici donc un script SQL Server pour modifier la table client et y ajouter une contrainte de cl\u00e9 primaire.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ALTER TABLE dbo.Customers \n\tADD CONSTRAINT [CustomersPrimaryKeyCustomerID] \n\t\tPRIMARY KEY CLUSTERED ([CustomerID] ASC);\nGO <\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"937\" height=\"573\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/add_sql_server_primary_key_to_table.jpg\" alt=\"Cr\u00e9er une table SQL Server avec une cl\u00e9 primaire (contrainte)\" class=\"wp-image-8955\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/add_sql_server_primary_key_to_table.jpg 937w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/add_sql_server_primary_key_to_table-300x183.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/add_sql_server_primary_key_to_table-768x470.jpg 768w\" sizes=\"auto, (max-width: 937px) 100vw, 937px\" \/><figcaption class=\"wp-element-caption\"><strong><em>Cr\u00e9er une table SQL Server avec une cl\u00e9 primaire (contrainte)<\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-inserer-2-lignes-avec-le-meme-numero-pour-tester-la-contrainte\">3. Ins\u00e9rer 2 lignes avec le m\u00eame num\u00e9ro pour tester la contrainte<\/h2>\n\n\n\n<p>En effet, la seule fa\u00e7on de v\u00e9rifier la contrainte de cl\u00e9 primaire est de l&rsquo;utiliser. Ins\u00e9rer donc deux lignes avec le m\u00eame num\u00e9ro de client pour v\u00e9rifier si la contrainte fonctionne. Techniquement il n&rsquo;est pas possible d&rsquo;ins\u00e9rer plusieurs lignes avec le m\u00eame ID dans la m\u00eame table SQL Server et une le syst\u00e8me renvoie une <a href=\"https:\/\/expert-only.com\/fr\/erreurs\/\">erreur SQL Server<\/a>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Ins\u00e9rer deux lignes diff\u00e9rente avec le m\u00eame num\u00e9ro de client\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 1, 'Ali','Ahmed','Cairo','Egypt');\n\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 1, 'Johnny','John','Toronto','Canada');\n<\/pre>\n\n\n\n<p>Noter l&rsquo;erreur de violation de la contrainte de cl\u00e9 primaire :<\/p>\n\n\n\n<p><em>Violation de la contrainte PRIMARY KEY &lsquo;CustomersPrimaryKeyCustomerID&rsquo;. Impossible d&rsquo;ins\u00e9rer la cl\u00e9 en double dans l&rsquo;objet &lsquo;dbo.Customers&rsquo;. La valeur de la cl\u00e9 en double est (1).<br>L&rsquo;instruction a \u00e9t\u00e9 interrompue.<\/em><\/p>\n\n\n\n<p>Ins\u00e9rer dans la table deux lignes diff\u00e9rentes avec le m\u00eame ID client n&rsquo;est donc pas possible gr\u00e2ce \u00e0 la contrainte ajout\u00e9e \u00e0 la table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-verifier-les-donnees-inserees-et-le-fonctionnement-de-la-cle\">4. V\u00e9rifier les donn\u00e9es ins\u00e9r\u00e9es et le fonctionnement de la cl\u00e9<\/h2>\n\n\n\n<p>Apr\u00e8s cela, une seule ligne unique est disponible dans la table avec l&rsquo;ID num\u00e9ro 1. C&rsquo;est donc uniquement la premi\u00e8re ligne de la commande d&rsquo;insertion qui est visible dans la table. Utiliser un <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Select_(SQL)\" target=\"_blank\" rel=\"noreferrer noopener\">select<\/a> pour lire la table.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- V\u00e9rifier le nombre de lignes ins\u00e9r\u00e9es\nSELECT * \nFROM dbo.Customers;\n<\/pre>\n\n\n\n<p>Il n&rsquo;est maintenant possible d&rsquo;attribuer qu&rsquo;une seule valeur \u00e0 un ID client, cela le rend unique dans la table. Pour aller plus loin, il faut noter quelques \u00e9l\u00e9ments concernant les cl\u00e9s primaires de SQL Server. Cependant, ces limitations et comportements sp\u00e9cifiques aux cl\u00e9s primaires font partie int\u00e9grante de leur fonctionnement :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Premi\u00e8rement, une seule cl\u00e9 primaire par table.<\/li>\n\n\n\n<li>Une cl\u00e9 primaire peut \u00eatre une cl\u00e9 compos\u00e9e utilisant plusieurs colonnes. Par exemple, une concat\u00e9nation de ces colonnes : ID + Pr\u00e9nom + Nom.<\/li>\n\n\n\n<li>De plus, une colonne utilis\u00e9e comme cl\u00e9 primaire ne peut pas \u00eatre NULL, elle est donc d\u00e9finie comme NOT NULL.<\/li>\n\n\n\n<li>De plus, une cl\u00e9 primaire a par d\u00e9faut son index cluster correspondant cr\u00e9\u00e9 automatiquement.<\/li>\n\n\n\n<li>Si cela est sp\u00e9cifi\u00e9 dans le script, l&rsquo;index peut \u00e9galement \u00eatre un index non-cluster.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">5. Conclusion sur les contraintes de clefs primaires SQL Server<\/h2>\n\n\n\n<p>En conclusion, ce tutoriel T-SQL explique de mani\u00e8re concise comment ajouter une contrainte de cl\u00e9 primaire \u00e0 une table SQL Server afin d&rsquo;\u00e9viter les doublons et maintenir l&rsquo;int\u00e9grit\u00e9 de la base de donn\u00e9es. En suivant les quatre \u00e9tapes d\u00e9taill\u00e9es, il est possible de cr\u00e9er une table et d&rsquo;ajouter une contrainte de cl\u00e9 primaire en utilisant la commande T-SQL ADD CONSTRAINT PRIMARY KEY.<\/p>\n\n\n\n<p>Il est \u00e9galement important de noter les limitations et comportements sp\u00e9cifiques des cl\u00e9s primaires de SQL Server. Pour en apprendre plus sur les objets SQL, voici comment <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/vue-partitionnee-sql-server-plusieurs-tables\/\">cr\u00e9er une vue partitionn\u00e9e SQL Server \u00e9tape par \u00e9tape<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"zq6aPJPFiB\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/vue-partitionnee-sql-server-plusieurs-tables\/\">Cr\u00e9er une vue partitionn\u00e9e SQL Server pour regrouper des tables<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Cr\u00e9er une vue partitionn\u00e9e SQL Server pour regrouper des tables\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/vue-partitionnee-sql-server-plusieurs-tables\/embed\/#?secret=OuOUodMx9D#?secret=zq6aPJPFiB\" data-secret=\"zq6aPJPFiB\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment cr\u00e9er une table SQL Server avec une contrainte de cl\u00e9 primaire pour \u00e9viter les donn\u00e9es en double ? Tutoriel pour cr\u00e9er une table SQL Server avec une cl\u00e9 primaire pour identifier une ligne de donn\u00e9es par une valeur <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/\" title=\"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10807,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-8949","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server? T-SQL<\/title>\n<meta name=\"description\" content=\"Cr\u00e9er une table SQL Server avec une contrainte de cl\u00e9 primaire sur une ou plusieurs colonnes pour mieux g\u00e9rer l&#039;int\u00e9grit\u00e9 des donn\u00e9es.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server?\" \/>\n<meta property=\"og:description\" content=\"Cr\u00e9er une table SQL Server avec une contrainte de cl\u00e9 primaire sur une ou plusieurs colonnes pour mieux g\u00e9rer l&#039;int\u00e9grit\u00e9 des donn\u00e9es.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-07T04:15:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-24T12:29:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server?\",\"datePublished\":\"2023-08-07T04:15:00+00:00\",\"dateModified\":\"2023-10-24T12:29:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/\"},\"wordCount\":739,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/\",\"name\":\"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg\",\"datePublished\":\"2023-08-07T04:15:00+00:00\",\"dateModified\":\"2023-10-24T12:29:05+00:00\",\"description\":\"Cr\u00e9er une table SQL Server avec une contrainte de cl\u00e9 primaire sur une ou plusieurs colonnes pour mieux g\u00e9rer l'int\u00e9grit\u00e9 des donn\u00e9es.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server? T-SQL","description":"Cr\u00e9er une table SQL Server avec une contrainte de cl\u00e9 primaire sur une ou plusieurs colonnes pour mieux g\u00e9rer l'int\u00e9grit\u00e9 des donn\u00e9es.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server?","og_description":"Cr\u00e9er une table SQL Server avec une contrainte de cl\u00e9 primaire sur une ou plusieurs colonnes pour mieux g\u00e9rer l'int\u00e9grit\u00e9 des donn\u00e9es.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-07T04:15:00+00:00","article_modified_time":"2023-10-24T12:29:05+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server?","datePublished":"2023-08-07T04:15:00+00:00","dateModified":"2023-10-24T12:29:05+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/"},"wordCount":739,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/","name":"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg","datePublished":"2023-08-07T04:15:00+00:00","dateModified":"2023-10-24T12:29:05+00:00","description":"Cr\u00e9er une table SQL Server avec une contrainte de cl\u00e9 primaire sur une ou plusieurs colonnes pour mieux g\u00e9rer l'int\u00e9grit\u00e9 des donn\u00e9es.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/open-notebook-coffee-5349034B119_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server-cle-primaire\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment cr\u00e9er une cl\u00e9 primaire avec SQL Server?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/8949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=8949"}],"version-history":[{"count":3,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/8949\/revisions"}],"predecessor-version":[{"id":27653,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/8949\/revisions\/27653"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10807"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=8949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=8949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=8949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}