{"id":1949,"date":"2023-05-26T06:40:00","date_gmt":"2023-05-26T04:40:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=1949"},"modified":"2023-07-29T15:41:48","modified_gmt":"2023-07-29T13:41:48","slug":"creer-table-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/","title":{"rendered":"Cr\u00e9er une table SQL Server avec CREATE TABLE"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><strong><em>Exemple de script SQL Server Create Table pour cr\u00e9er une table de ventes et de clients.<\/em><\/strong><\/h4>\n\n\n\n<p>Ce code SQL est un script de type Language de D\u00e9finition de Donn\u00e9es (LDD) pour cr\u00e9er une table SQL Server. Ces tables servent d&rsquo;exemple dans de nombreux articles Transact-SQL du site sur Expert-Only. Ces scripts simples testent au pr\u00e9alable si la table existe, si elle existe alors elle est supprim\u00e9e. Ensuite, cr\u00e9er la table SQL Server des ventes. Deux colonnes la composent, une colonne pour les mois et une autre pour les montants des ventes mensuelles.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#1-exemple-de-script-sql-server-pour-creer-une-table-de-ventes\" >1. Exemple de script SQL Server pour cr\u00e9er une table de ventes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#2-creer-une-table-sql-server-avec-differents-types-de-donnees\" >2. Cr\u00e9er une table SQL Server avec diff\u00e9rents types de donn\u00e9es<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#3-requete-t-sql-pour-creer-une-table-clients-et-stocker-des-donnees\" >3. Requ\u00eate T-SQL pour cr\u00e9er une table clients et stocker des donn\u00e9es<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"block-3cdb5a5c-6a98-409c-96b9-7948dccdf68c\"><span class=\"ez-toc-section\" id=\"1-exemple-de-script-sql-server-pour-creer-une-table-de-ventes\"><\/span>1. Exemple de script SQL Server pour cr\u00e9er une table de ventes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p id=\"block-83165bda-74c0-4732-8d81-5b6a2ced90ef\">Il suffit de COPIER \/ COLLER le script dans SQL Server Management Studio (SSMS) par exemple. Cette table contient deux colonnes :<\/p>\n\n\n\n<ul class=\"wp-block-list\" id=\"block-aa96d7aa-277e-4b7c-8270-472758a92a4f\">\n<li>Une colonne MOIS de type NVARCHAR(20)<\/li>\n\n\n\n<li>Une colonne MONTANT de type NUMERIC(5)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">1.1 Tester et supprimer la table si besoin<\/h3>\n\n\n\n<p id=\"block-578d7104-fc34-4e7f-8aa7-2f420134be4f\">Pour commencer, tester si la table existe dans la base avec la fonction Exists(). Si c&rsquo;est le cas alors la table est supprim\u00e9e avec <a href=\"https:\/\/expert-only.com\/t-sql\/supprimer-table-sql-server\/\">la commande T-SQL drop table<\/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=\"\">-- Tester si la table existe d\u00e9j\u00e0\n-- Si oui alors supprimer la table\nIF exists ( \n\tSELECT 1 FROM sys.objects\n     WHERE  object_id = object_id(N'[dbo].[VENTES]')\n\tAND type in (N'U')  \n)\nBEGIN \t\n\tDROP TABLE [dbo].[VENTES]\nEND\nGO<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-578d7104-fc34-4e7f-8aa7-2f420134be4f\">1.2 Cr\u00e9er la table avec le script SQL<\/h3>\n\n\n\n<p id=\"block-578d7104-fc34-4e7f-8aa7-2f420134be4f\">Cr\u00e9er ensuite la table VENTES qui contient les 2 colonnes:<\/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 d'exemple pour stocker les VENTES\nCREATE  table [dbo].[VENTES] (\n\t[MOIS]       nvarchar(20),\n\t[MONTANT]    numeric(5)\n)\nGO\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"675\" height=\"514\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png\" alt=\"Script SQL Server pour cr\u00e9er une table depuis SSMS\" class=\"wp-image-1096\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png 675w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes-300x228.png 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes-80x60.png 80w\" sizes=\"auto, (max-width: 675px) 100vw, 675px\" \/><figcaption class=\"wp-element-caption\">Script SQL Server pour cr\u00e9er une table depuis SSMS<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">1.3 Ins\u00e9rer des donn\u00e9es dans la table<\/h3>\n\n\n\n<p>Insertion de quelques lignes dans la table pour manipuler les donn\u00e9es pour les trois premiers mois de l&rsquo;ann\u00e9e civile.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Ins\u00e9rer des donn\u00e9es de Ventes pour notre exemple\nINSERT INTO dbo.VENTES ( MOIS, MONTANT ) VALUES  ( N'Janvier', 1000);\nINSERT INTO dbo.VENTES ( MOIS, MONTANT ) VALUES  ( N'F\u00e9vrier', 2000);\nINSERT INTO dbo.VENTES ( MOIS, MONTANT ) VALUES  ( N'Mars', 3000);\nGO\n\n-- S\u00e9lectionner les r\u00e9sultats pour contr\u00f4ler le contenu de table\nSELECT * \nFROM   dbo.VENTES;\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\" id=\"block-78b4bd52-2131-458b-87e9-1297bdfeeaca\"><img decoding=\"async\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SELECT-SQL-Server-Resultat-Ventes.png\" alt=\"S\u00e9lectionner les donn\u00e9es de la table SQL Server\"\/><figcaption class=\"wp-element-caption\">S\u00e9lectionner les donn\u00e9es de la table SQL Server<\/figcaption><\/figure><\/div>\n\n\n<p id=\"block-386182c2-a698-48ae-aca9-92081bf0f2cb\">Cet article d\u00e9crit un exemple en langage Transact-sql pour cr\u00e9er une table qui contient des donn\u00e9es de ventes mensuelles. Les autres <a href=\"https:\/\/kost-ceco.ch\/cms\/kad_sql-script_fr.html\" target=\"_blank\" rel=\"noreferrer noopener\">scripts SQL<\/a> du blog utilisent cet exemple, volontairement basique.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-creer-une-table-sql-server-avec-differents-types-de-donnees\"><span class=\"ez-toc-section\" id=\"2-creer-une-table-sql-server-avec-differents-types-de-donnees\"><\/span>2. Cr\u00e9er une table SQL Server avec diff\u00e9rents types de donn\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Cet exemple de cr\u00e9ation d&rsquo;une table des Ventes utilise diff\u00e9rents types de donn\u00e9es. Les colonnes sont par exemple de types binaires, num\u00e9riques, entiers ou encore chaines de caract\u00e8res. Une solution possible est d&rsquo;utiliser une commande T-SQL CREATE TABLE.&nbsp;Par exemple, voici un extrait de code facile \u00e0 adapter \u00e0 diff\u00e9rents besoins pour cr\u00e9er une nouvelle table. <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE [dbo].[VENTES] \n(\n [MoisNom] NVARCHAR(50), -- alphanum\u00e9rique\n [MoisCourant]  BIT, -- bool\u00e9en, 0 ou 1 , false \/ true\n [NumeroMois] TINYINT, -- tr\u00e8s petit entier, de 0 \u00e0 255\n [NumeroEmploye] SMALLINT, -- petit entier, minimum -2^15, maximum 2^15\n [NombreClients] INTEGER, -- entier, minimum -2^31, maximum 2^31\n [NombreVentes] BIGINT, -- grand entier, minimum: -2^63, maximum 2^63\n [Montant_HT] NUMERIC(15,5), -- num\u00e9rique, 15 chiffres, dont 5 apr\u00e8s la virgule\n [Montant_TTC] DECIMAL(15,5) -- d\u00e9cimal, 15 chiffres, dont 5 apr\u00e8s la virgule\n);\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-requete-t-sql-pour-creer-une-table-clients-et-stocker-des-donnees\"><\/span>3. Requ\u00eate T-SQL pour cr\u00e9er une table clients et stocker des donn\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ce troisi\u00e8me exemple concerne la table CLIENTS qui est utilis\u00e9 dans de nombreux tutoriels. Ensuite la table SQL Server appel\u00e9e [dbo].[CLIENTS] est cr\u00e9\u00e9e. De la m\u00eame mani\u00e8re, il suffit de COPIER \/ COLLER le script dans votre outil de gestion de base SQL Server, comme <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/ssms\/sql-server-management-studio-ssms?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SSMS<\/a> par exemple.<\/p>\n\n\n\n<p id=\"block-a71cd663-8e36-4119-9e18-390d36c80862\">Cette table CLIENTS contient trois colonnes :<\/p>\n\n\n\n<ol class=\"wp-block-list\" id=\"block-839107bf-19b2-411b-b3db-606ac3e9db7c\">\n<li>Une premi\u00e8re colonne NOCLIENT de type int et auto-incr\u00e9ment\u00e9e.<\/li>\n\n\n\n<li>Une colonne NOM de type nvarchar(20) et UNIQUE.<\/li>\n\n\n\n<li>Une derni\u00e8re colonne VILLE de type nvarchar(20).<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Tester si la table CLIENTS existe d\u00e9j\u00e0\n-- Et la supprimer au besoin\nIF EXISTS( \t\n\tSELECT \t1 FROM sys.objects\n\tWHERE \tobject_id = object_id(N'[dbo].[CLIENTS]') \n\t\tAND type in (N'U')\n)\nBEGIN\n\tDROP TABLE [dbo].[CLIENTS]\nEND\nGO\n\n-- Cr\u00e9er la table CLIENTS avec la colonne NOM d\u00e9clar\u00e9e comme UNIQUE\n-- Le mot clef UNIQUE d\u00e9finit la colonne avec une valeur unique\n-- Ins\u00e9rer deux clients avec le m\u00eame nom est donc impossible\nCREATE TABLE [dbo].[CLIENTS] (\n\t[NOCLIENT] int IDENTITY(1,1),\n\t[NOM]   \t nvarchar(20) UNIQUE,\n\t[VILLE] \t nvarchar(20)\n)\nGO\n\n-- Ins\u00e9rer des donn\u00e9es pour les exemples de manipulation\nINSERT INTO dbo.CLIENTS ( NOM, VILLE ) VALUES ( N'MAMMADOU', 'Lyon');\nINSERT INTO dbo.CLIENTS ( NOM, VILLE ) VALUES ( N'SERGEI', 'Lyon');\nINSERT INTO dbo.CLIENTS ( NOM, VILLE ) VALUES ( N'CHRISTOPHE', 'Paris');\n\n-- V\u00e9rifier des lignes ins\u00e9r\u00e9es\nSELECT * \nFROM dbo.CLIENTS;\n<\/pre>\n\n\n\n<p id=\"block-4e82d3f6-ef79-430a-9d89-6e46398650dd\">Pour continuer dans le sens de la manipulation et du stockage de donn\u00e9es en base, voici comment <a href=\"https:\/\/expert-only.com\/t-sql\/creer-vue-sql-server-avec-script\/\">cr\u00e9er une vue SQL \u00e0 partir d&rsquo;une table<\/a>. Cet autre tutoriel explique comment <a href=\"https:\/\/expert-only.com\/t-sql\/requete-sql-server-unpivot\/\">transposer les colonnes en lignes avec la requ\u00eate SQL UNPIVOT<\/a>.<\/p>\n\n\n\n<p>En conclusion, SQL Server propose de nombreux formats de donn\u00e9es, alphanum\u00e9riques ou num\u00e9riques. Adapter l&rsquo;utilisation des formats et des tailles de colonnes au besoin effectif pour mieux g\u00e9rer l&rsquo;espace disque des bases de donn\u00e9es sur les serveurs. Pour aller plus loin, cet article explique <a href=\"https:\/\/expert-only.com\/tables\/modifier-table-sql-server\/\">comment modifier le type de donn\u00e9es d&rsquo;une colonne SQL Server<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter 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=\"HzDlPHXmwW\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-colonne-sql-server\/\">Modifier une colonne SQL Server avec un script<\/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\u00a0Modifier une colonne SQL Server avec un script\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-colonne-sql-server\/embed\/#?secret=iMj8lXZXuI#?secret=HzDlPHXmwW\" data-secret=\"HzDlPHXmwW\" 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>Exemple de script SQL Server Create Table pour cr\u00e9er une table de ventes et de clients. Ce code SQL est un script de type Language de D\u00e9finition de Donn\u00e9es (LDD) pour cr\u00e9er une table SQL Server. Ces tables servent <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/\" title=\"Cr\u00e9er une table SQL Server avec CREATE TABLE\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1949","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"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>Cr\u00e9er une table SQL Server avec CREATE TABLE - T-SQL<\/title>\n<meta name=\"description\" content=\"Exemples de scripts SQL Server Create Table pour cr\u00e9er une table de ventes et de clients, pour stocker et g\u00e9rer les donn\u00e9es en T-SQL.\" \/>\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\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er une table SQL Server avec CREATE TABLE\" \/>\n<meta property=\"og:description\" content=\"Exemples de scripts SQL Server Create Table pour cr\u00e9er une table de ventes et de clients, pour stocker et g\u00e9rer les donn\u00e9es en T-SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/\" \/>\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-05-26T04:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-29T13:41:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png\" \/>\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=\"3 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\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Cr\u00e9er une table SQL Server avec CREATE TABLE\",\"datePublished\":\"2023-05-26T04:40:00+00:00\",\"dateModified\":\"2023-07-29T13:41:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/\"},\"wordCount\":581,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/\",\"name\":\"Cr\u00e9er une table SQL Server avec CREATE TABLE - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png\",\"datePublished\":\"2023-05-26T04:40:00+00:00\",\"dateModified\":\"2023-07-29T13:41:48+00:00\",\"description\":\"Exemples de scripts SQL Server Create Table pour cr\u00e9er une table de ventes et de clients, pour stocker et g\u00e9rer les donn\u00e9es en T-SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er une table SQL Server avec CREATE TABLE\"}]},{\"@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":"Cr\u00e9er une table SQL Server avec CREATE TABLE - T-SQL","description":"Exemples de scripts SQL Server Create Table pour cr\u00e9er une table de ventes et de clients, pour stocker et g\u00e9rer les donn\u00e9es en T-SQL.","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\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er une table SQL Server avec CREATE TABLE","og_description":"Exemples de scripts SQL Server Create Table pour cr\u00e9er une table de ventes et de clients, pour stocker et g\u00e9rer les donn\u00e9es en T-SQL.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-05-26T04:40:00+00:00","article_modified_time":"2023-07-29T13:41:48+00:00","og_image":[{"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png","type":"","width":"","height":""}],"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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Cr\u00e9er une table SQL Server avec CREATE TABLE","datePublished":"2023-05-26T04:40:00+00:00","dateModified":"2023-07-29T13:41:48+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/"},"wordCount":581,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/","name":"Cr\u00e9er une table SQL Server avec CREATE TABLE - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png","datePublished":"2023-05-26T04:40:00+00:00","dateModified":"2023-07-29T13:41:48+00:00","description":"Exemples de scripts SQL Server Create Table pour cr\u00e9er une table de ventes et de clients, pour stocker et g\u00e9rer les donn\u00e9es en T-SQL.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/Script-SQL-Server-Create-Table-Ventes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er une table SQL Server avec CREATE TABLE"}]},{"@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\/1949","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=1949"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1949\/revisions"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}