{"id":2030,"date":"2022-07-19T06:37:00","date_gmt":"2022-07-19T04:37:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=2030"},"modified":"2023-02-13T15:51:37","modified_gmt":"2023-02-13T14:51:37","slug":"modifier-vue-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/","title":{"rendered":"Modifier une vue SQL Server (Alter View)"},"content":{"rendered":"\n<p>Comment modifier une vue SQL Server avec un script T-SQL ? Cet exemple de code permet de modifier une vue existante. Il suffit d&rsquo;utiliser la commande g\u00e9n\u00e9rique ALTER et VIEW. Par exemple pour supprimer une colonne de la vue existante ou encore ajouter une colonne calcul\u00e9e \u00e0 partir d&rsquo;autre colonnes de la table source.<\/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\/modifier-vue-sql-server\/#1-exemples-pour-modifier-une-vue-sql-server-avec-alter-view\" >1. Exemples pour modifier une vue SQL Server avec Alter View<\/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\/modifier-vue-sql-server\/#2-supprimer-une-colonne-depuis-une-vue-en-t-sql\" >2. Supprimer une colonne depuis une vue en T-SQL<\/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\/modifier-vue-sql-server\/#3-ajouter-une-colonne-a-une-vue-existante-en-t-sql\" >3. Ajouter une colonne \u00e0 une vue existante en T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#4-modifier-une-ou-plusieurs-colonnes-dans-une-vue-sql-server\" >4. Modifier une ou plusieurs colonnes dans une vue SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#5-ajouter-une-condition-where-a-une-vue-ms-sql\" >5. Ajouter une condition WHERE \u00e0 une vue MS SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#6-renommer-une-vue-avec-un-script-t-sql\" >6. Renommer une vue avec un script T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#7-conclusion-sur-la-modification-des-vues-sql-server\" >7. Conclusion sur la modification des vues SQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-exemples-pour-modifier-une-vue-sql-server-avec-alter-view\"><span class=\"ez-toc-section\" id=\"1-exemples-pour-modifier-une-vue-sql-server-avec-alter-view\"><\/span>1. Exemples pour modifier une vue SQL Server avec Alter View<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En effet, ces scripts T-SQL permettent de modifier une <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Vue_(base_de_donn%C3%A9es)\" target=\"_blank\" rel=\"noopener noreferrer\">vue<\/a> existante dans une base de donn\u00e9es. Par exemple pour supprimer la colonne Nombre de clients, nomm\u00e9e NombreClients. Pour qu&rsquo;elle n&rsquo;apparaisse plus dans la liste de colonnes de la nouvelle vue.<\/p>\n\n\n\n<p>La vue SQL Server <em>V_Ventes<\/em> contient donc des donn\u00e9es de ventes. Le code source de la vue initiale est disponible dans cet article qui explique <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-script\/\">comment cr\u00e9er une vue SQL Server<\/a>. Il faut donc ex\u00e9cuter le code source de la vue au pr\u00e9alable pour ex\u00e9cuter le suivant.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-supprimer-une-colonne-depuis-une-vue-en-t-sql\"><\/span>2. Supprimer une colonne depuis une vue en T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ex\u00e9cuter donc le code suivant pour pouvoir modifier la vue comme suit: <\/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=\"\">ALTER VIEW [dbo].[V_VENTES]\nAS\n\tSELECT\n\t\t[NombreVentes], -- Suppression de la colonne [NombreClients]\n\t\t[Montant_HT],\n\t\t[Montant_TTC]\n\tFROM [dbo].[VENTES];\n<\/pre>\n\n\n\n<p>En effet les colonnes sont lues depuis la table source. Et une vue permet justement de s\u00e9lectionner uniquement les donn\u00e9es utiles. De mani\u00e8re horizontale (avec les colonnes choisies) et verticale (avec le filtre sur les donn\u00e9es avec la commande SELECT). Noter qu&rsquo;il existe une astuce tr\u00e8s simple pour s&rsquo;assurer que la s\u00e9lection dans le script de la vue fonctionne parfaitement.<\/p>\n\n\n\n<p>L&rsquo;objectif est donc de d\u00e9velopper la vue de code en deux \u00e9tapes successives.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La premi\u00e8re consiste \u00e0 la tester comme une simple s\u00e9lection jusqu&rsquo;\u00e0 ce que toutes les colonnes soient disponibles et que la requ\u00eate de s\u00e9lection soit termin\u00e9e conform\u00e9ment aux exigences du projet.<\/li>\n\n\n\n<li>Ensuite, il faut int\u00e9grer l&rsquo;instruction select au script de la vue sans probl\u00e8me.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-ajouter-une-colonne-a-une-vue-existante-en-t-sql\"><\/span>3. Ajouter une colonne \u00e0 une vue existante en T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour ajouter une colonne \u00e0 une vue existante, utilisez la commande ALTER VIEW suivie de la commande AS et de la nouvelle liste de colonnes. Par exemple :<\/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=\"\">ALTER VIEW [dbo].[V_VENTES]\nAS\nSELECT\n\t[NombreVentes],\n\t[Montant_HT],\n\t[Montant_TTC],\n\t[DateVente] -- Ajout de la colonne [DateVente]\nFROM [dbo].[VENTES];<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-modifier-une-ou-plusieurs-colonnes-dans-une-vue-sql-server\"><\/span>4. Modifier une ou plusieurs colonnes dans une vue SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour modifier une colonne dans une vue existante, utilisez la commande ALTER VIEW suivie de la commande AS et de la nouvelle liste de colonnes, en modifiant simplement la colonne existante. Utiliser par exemple ce code \u00e9crit en langage T-SQL pour transformer la colonne avec les montant HT en montants avec TVA.<\/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=\"\">ALTER VIEW [dbo].[V_VENTES]\nAS\nSELECT\n[NombreVentes],\n[Montant_HT] * 1.2 AS [Montant_HT_TVA], -- Modification de la colonne [Montant_HT]\n[Montant_TTC],\n[DateVente]\nFROM [dbo].[VENTES];<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-ajouter-une-condition-where-a-une-vue-ms-sql\"><\/span>5. Ajouter une condition WHERE \u00e0 une vue MS SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour ajouter une condition WHERE \u00e0 une vue existante pour filtrer les donn\u00e9es, utilisez la commande ALTER VIEW suivie de la commande AS. Puis utiliser la nouvelle liste de colonnes, avec la condition WHERE ajout\u00e9e apr\u00e8s la commande FROM, comme dans <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\">une requ\u00eate classique de s\u00e9lection de donn\u00e9es<\/a>.<\/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=\"\">ALTER VIEW [dbo].[V_VENTES]\nAS\nSELECT\n[NombreVentes],\n[Montant_HT],\n[Montant_TTC],\n[DateVente]\nFROM [dbo].[VENTES]\nWHERE [DateVente] BETWEEN '2022-01-01' AND '2022-12-31';<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-renommer-une-vue-avec-un-script-t-sql\"><\/span>6. Renommer une vue avec un script T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Enfin, pour renommer une vue, il faut utiliser cette fois une proc\u00e9dure stock\u00e9e syst\u00e8me. En effet, utiliser la commande sp_rename en sp\u00e9cifiant l&rsquo;ancien nom et le nouveau nom. Par exemple, le code suivant renomme la vue V_VENTES en V_VENTES_2022, pour \u00eatre coh\u00e9rent avec le filtre appliqu\u00e9 dans l&rsquo;exemple pr\u00e9c\u00e9dent. <\/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=\"\">EXEC sp_rename 'dbo.V_VENTES', 'V_VENTES_2022';<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7-conclusion-sur-la-modification-des-vues-sql-server\"><\/span>7. Conclusion sur la modification des vues SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En conclusion, cet article nous a pr\u00e9sent\u00e9 des exemples pratiques de scripts T-SQL permettant de modifier des vues existantes dans une base de donn\u00e9es Microsoft SQL Server. Nous avons appris qu&rsquo;il est possible de supprimer une colonne de la vue, d&rsquo;ajouter une colonne calcul\u00e9e \u00e0 partir d&rsquo;autres colonnes de la table source, de modifier une ou plusieurs colonnes existantes et d&rsquo;ajouter une condition WHERE pour filtrer les donn\u00e9es.<\/p>\n\n\n\n<p>Enfin, nous avons \u00e9galement appris comment renommer une vue en utilisant la commande sp_rename. Ces exemples pratiques sont utiles pour les administrateurs de base de donn\u00e9es qui souhaitent effectuer des modifications sur des vues existantes, tout en conservant la flexibilit\u00e9 et les avantages offerts par les vues.<\/p>\n\n\n\n<p>Si besoin, voici comment <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/\">supprimer une vue apr\u00e8s un test d&rsquo;existence avant de la recr\u00e9er<\/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=\"7s4oyI2QeH\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/\">Tester et supprimer une vue SQL Server si elle existe<\/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\u00a0Tester et supprimer une vue SQL Server si elle existe\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/embed\/#?secret=WLHyPkWssz#?secret=7s4oyI2QeH\" data-secret=\"7s4oyI2QeH\" 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 modifier une vue SQL Server avec un script T-SQL ? Cet exemple de code permet de modifier une vue existante. Il suffit d&rsquo;utiliser la commande g\u00e9n\u00e9rique ALTER et VIEW. Par exemple pour supprimer une colonne de la vue <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/\" title=\"Modifier une vue SQL Server (Alter View)\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10617,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-2030","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>Modifier une vue SQL Server (Alter View) - Tutoriels T-SQL<\/title>\n<meta name=\"description\" content=\"Exemples de code pour modifier une vue SQL Server avec la commande T-SQL Alter View, il faut modifier la requ\u00eate source de la vue.\" \/>\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\/modifier-vue-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Modifier une vue SQL Server (Alter View)\" \/>\n<meta property=\"og:description\" content=\"Exemples de code pour modifier une vue SQL Server avec la commande T-SQL Alter View, il faut modifier la requ\u00eate source de la vue.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-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=\"2022-07-19T04:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-13T14:51:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_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\/modifier-vue-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Modifier une vue SQL Server (Alter View)\",\"datePublished\":\"2022-07-19T04:37:00+00:00\",\"dateModified\":\"2023-02-13T14:51:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/\"},\"wordCount\":708,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/\",\"name\":\"Modifier une vue SQL Server (Alter View) - Tutoriels T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg\",\"datePublished\":\"2022-07-19T04:37:00+00:00\",\"dateModified\":\"2023-02-13T14:51:37+00:00\",\"description\":\"Exemples de code pour modifier une vue SQL Server avec la commande T-SQL Alter View, il faut modifier la requ\u00eate source de la vue.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Modifier une vue SQL Server (Alter View)\"}]},{\"@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":"Modifier une vue SQL Server (Alter View) - Tutoriels T-SQL","description":"Exemples de code pour modifier une vue SQL Server avec la commande T-SQL Alter View, il faut modifier la requ\u00eate source de la vue.","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\/modifier-vue-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Modifier une vue SQL Server (Alter View)","og_description":"Exemples de code pour modifier une vue SQL Server avec la commande T-SQL Alter View, il faut modifier la requ\u00eate source de la vue.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-07-19T04:37:00+00:00","article_modified_time":"2023-02-13T14:51:37+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_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\/modifier-vue-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Modifier une vue SQL Server (Alter View)","datePublished":"2022-07-19T04:37:00+00:00","dateModified":"2023-02-13T14:51:37+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/"},"wordCount":708,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/","name":"Modifier une vue SQL Server (Alter View) - Tutoriels T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg","datePublished":"2022-07-19T04:37:00+00:00","dateModified":"2023-02-13T14:51:37+00:00","description":"Exemples de code pour modifier une vue SQL Server avec la commande T-SQL Alter View, il faut modifier la requ\u00eate source de la vue.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-vue-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Modifier une vue SQL Server (Alter View)"}]},{"@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\/2030","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=2030"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/2030\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10617"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=2030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=2030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=2030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}