{"id":2035,"date":"2022-11-07T06:25:00","date_gmt":"2022-11-07T05:25:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=2035"},"modified":"2022-12-01T07:39:37","modified_gmt":"2022-12-01T06:39:37","slug":"tester-et-supprimer-une-vue-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/","title":{"rendered":"Tester et supprimer une vue SQL Server si elle existe"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Comment tester et ensuite supprimer une vue SQL Server, si elle existe dans la base de donn\u00e9es ?<\/em><\/strong><\/h4>\n\n\n\n<p>Voici comment tester l&rsquo;existence d&rsquo;une une vue SQL Server avant de la supprimer. Utiliser ce script comme un exemple pour tester l&rsquo;existence de la vue avant de la supprimer. L&rsquo;objectif est de ne pas g\u00e9n\u00e9rer d&rsquo;erreur pendant l&rsquo;ex\u00e9cution d&rsquo;un script de d\u00e9ploiement par exemple. Et ainsi de ne pas ex\u00e9cuter un script sur un objet inexistant, ou renomm\u00e9 par exemple.<\/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\/tester-et-supprimer-une-vue-sql-server\/#1-supprimer-une-vue-sql-server-si-elle-existe\" >1. Supprimer une vue SQL Server si elle existe<\/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\/tester-et-supprimer-une-vue-sql-server\/#2-supprimer-une-vue-a-partir-de-la-version-2016\" >2. Supprimer une vue \u00e0 partir de la version 2016<\/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\/tester-et-supprimer-une-vue-sql-server\/#3-supprimer-toutes-les-vues-dune-base-sql-server\" >3. Supprimer toutes les vues d&rsquo;une base SQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-supprimer-une-vue-sql-server-si-elle-existe\"><span class=\"ez-toc-section\" id=\"1-supprimer-une-vue-sql-server-si-elle-existe\"><\/span>1. Supprimer une vue SQL Server si elle existe<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En effet, supprimer une vue inexistante retourne cette erreur dans SQL Server Management Studio (SSMS).&nbsp;<\/p>\n\n\n\n<p><em>Cannot drop the view &lsquo;dbo.V_VENTES&rsquo;, because it does not exist or you do not have permission.<\/em><\/p>\n\n\n\n<p>Ou le m\u00eame message d&rsquo;erreur en Fran\u00e7ais : <\/p>\n\n\n\n<p><em>Msg 3701 : La vue n&rsquo;existe pas ou vous n&rsquo;avez pas les droits.<\/em><\/p>\n\n\n\n<p>Voici la solution, utiliser la fonction SQL Server IF <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/t-sql\/language-elements\/exists-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">EXISTS<\/a> pour tester l&rsquo;existence de la vue avant de la supprimer, comme dans cet exemple.<\/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=\"\">IF EXISTS ( \n  SELECT 1 \n  FROM sys.objects \n  WHERE object_id = object_id(N'[dbo].[V_VENTES]') \n  AND type in (N'V') \n) \nBEGIN DROP VIEW [dbo].[V_VENTES]; \nEND;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-supprimer-une-vue-a-partir-de-la-version-2016\"><\/span>2. Supprimer une vue \u00e0 partir de la version 2016<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Script plus court avec une seule ligne de code, la fonction <em>DROP VIEW IF EXISTS<\/em>, qui est disponible depuis la version <a href=\"https:\/\/expert-only.com\/astuces-excel\/driver-access-database-engine-2016-excel\/\">SQL Server 2016<\/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=\"\">IF EXISTS DROP VIEW [dbo].[V_VENTES];\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-supprimer-toutes-les-vues-dune-base-sql-server\"><\/span>3. Supprimer toutes les vues d&rsquo;une base SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Enfin, pour cette troisi\u00e8me partie sur la suppression des vues, voici comment cr\u00e9er un script dynamique avec une boucle pour filtrer et supprimer toutes les vues avec un pr\u00e9fixe ou un suffixe particulier. Ce code en plusieurs parties permet d&rsquo;automatiser ces \u00e9tapes :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Cr\u00e9er les variables<\/li>\n\n\n\n<li>Instancier les variables<\/li>\n\n\n\n<li>Cr\u00e9er un curseur pour s\u00e9lectionner le nom des vues avec un filtre sur le nom<\/li>\n\n\n\n<li>Parcourir le curseur<\/li>\n\n\n\n<li>Pour chaque ligne du curseur, construire et afficher une requ\u00eate pour supprimer la vue<\/li>\n\n\n\n<li>Fermer et supprimer la r\u00e9f\u00e9rence du curseur.<\/li>\n<\/ol>\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=\"\">DECLARE\n  @View_Name AS NVARCHAR(50),\n  @Drop_SQL_Query AS NVARCHAR(100),\n  @Drop_SQL_Query_Full AS NVARCHAR(200);\n\nSET @Drop_SQL_Query = 'IF EXISTS DROP VIEW ';\n\nDECLARE View_Name_Cursor CURSOR   FOR \n  SELECT [Name] \n  FROM SYS.VIEWS\n  WHERE [Name] LIKE '%_SALES_%'\n  ORDER BY [Name];\n\nOPEN View_Name_Cursor;\nFETCH NEXT FROM View_Name_Cursor into @View_Name;\n\nWHILE @@FETCH_STATUS = 0  \nBEGIN \n  SET @Drop_SQL_Query_Full = @Drop_SQL_Query + @View_Name;\n  PRINT @Drop_SQL_Query_Full;\n  --EXEC @Drop_SQL_Query_Full;\n  FETCH NEXT FROM View_Name_Cursor into @View_Name;\nEND\n\nCLOSE View_Name_Cursor;  \nDEALLOCATE View_Name_Cursor;  <\/pre>\n\n\n\n<p>En effet, ce script permet de supprimer toutes les vues cr\u00e9\u00e9es dans une base de donn\u00e9es. Il utilise un filtre, facilement modifiable pour s\u00e9lectionner les vues bas\u00e9es sur un suffixe, un pr\u00e9fixe, un filtre comme dans l&rsquo;exemple ci-dessus, ou encore simplement toutes les vues de la base.<\/p>\n\n\n\n<p>Ce script ne supprime pas les vues, mais g\u00e9n\u00e8re de fa\u00e7on dynamique les commandes pour supprimer les vues. Pour l&rsquo;ex\u00e9cuter directement \u00e0 l&rsquo;int\u00e9rieur du code T-SQL, retirer simplement les commentaires \u00e0 la ligne suivante.<\/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=\"\">EXEC sp_executesql @Drop_SQL_Query_Full;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"740\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sq-server-generate-script-to-drop-all-views-from-db-1.jpg\" alt=\"Tester et supprimer une vue SQL Server si elle existe - Supprimer toutes les vues SQL Server d'une base de donn\u00e9es\" class=\"wp-image-18382\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sq-server-generate-script-to-drop-all-views-from-db-1.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sq-server-generate-script-to-drop-all-views-from-db-1-292x300.jpg 292w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\"><strong>Supprimer toutes les vues SQL Server d&rsquo;une base de donn\u00e9es avec un script<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Ce sont des requ\u00eates de type Langage de D\u00e9finition de Donn\u00e9e (dont l&rsquo;abr\u00e9viation est <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/data-definition-language\" target=\"_blank\" rel=\"noreferrer noopener\">LDD<\/a>), appel\u00e9 aussi DDL pour Data Definition Language en Anglais. Cette page plus g\u00e9n\u00e9rale sur les vues expose quelques <a href=\"https:\/\/expert-only.com\/gerer-les-vues-sql-server\/\">exemples des principales commandes LDD pour g\u00e9rer les vues avec des scripts T-SQL<\/a>.<\/p>\n\n\n\n<p>Pour conclure, ce tutoriel explique Tester et supprimer une vue SQL Server avec les versions avant SQL Server 2016, et les suivantes en une seule ligne. Puis pr\u00e9sente un script dynamique pour supprimer toutes les vues d&rsquo;une base SQL. <\/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\">\nhttps:\/\/expert-only.com\/gerer-les-vues-sql-server\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment tester et ensuite supprimer une vue SQL Server, si elle existe dans la base de donn\u00e9es ? Voici comment tester l&rsquo;existence d&rsquo;une une vue SQL Server avant de la supprimer. Utiliser ce script comme un exemple pour tester <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/\" title=\"Tester et supprimer une vue SQL Server si elle existe\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10297,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-2035","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>Tester et supprimer une vue SQL Server si elle existe<\/title>\n<meta name=\"description\" content=\"Tester et supprimer une vue SQL Server si elle existe et \u00e9viter l&#039;erreur 3701, la vue n&#039;existe pas ou vous n&#039;avez pas les droits.\" \/>\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\/tester-et-supprimer-une-vue-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tester et supprimer une vue SQL Server si elle existe\" \/>\n<meta property=\"og:description\" content=\"Tester et supprimer une vue SQL Server si elle existe et \u00e9viter l&#039;erreur 3701, la vue n&#039;existe pas ou vous n&#039;avez pas les droits.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-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-11-07T05:25:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-01T06:39:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_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\/tester-et-supprimer-une-vue-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Tester et supprimer une vue SQL Server si elle existe\",\"datePublished\":\"2022-11-07T05:25:00+00:00\",\"dateModified\":\"2022-12-01T06:39:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/\"},\"wordCount\":531,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/\",\"name\":\"Tester et supprimer une vue SQL Server si elle existe\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_1920x1080.jpg\",\"datePublished\":\"2022-11-07T05:25:00+00:00\",\"dateModified\":\"2022-12-01T06:39:37+00:00\",\"description\":\"Tester et supprimer une vue SQL Server si elle existe et \u00e9viter l'erreur 3701, la vue n'existe pas ou vous n'avez pas les droits.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tester et supprimer une vue SQL Server si elle existe\"}]},{\"@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":"Tester et supprimer une vue SQL Server si elle existe","description":"Tester et supprimer une vue SQL Server si elle existe et \u00e9viter l'erreur 3701, la vue n'existe pas ou vous n'avez pas les droits.","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\/tester-et-supprimer-une-vue-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Tester et supprimer une vue SQL Server si elle existe","og_description":"Tester et supprimer une vue SQL Server si elle existe et \u00e9viter l'erreur 3701, la vue n'existe pas ou vous n'avez pas les droits.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-07T05:25:00+00:00","article_modified_time":"2022-12-01T06:39:37+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_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\/tester-et-supprimer-une-vue-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Tester et supprimer une vue SQL Server si elle existe","datePublished":"2022-11-07T05:25:00+00:00","dateModified":"2022-12-01T06:39:37+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/"},"wordCount":531,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/","name":"Tester et supprimer une vue SQL Server si elle existe","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_1920x1080.jpg","datePublished":"2022-11-07T05:25:00+00:00","dateModified":"2022-12-01T06:39:37+00:00","description":"Tester et supprimer une vue SQL Server si elle existe et \u00e9viter l'erreur 3701, la vue n'existe pas ou vous n'avez pas les droits.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/backspace-typewriter-key-B42D0B1865C_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/tester-et-supprimer-une-vue-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Tester et supprimer une vue SQL Server si elle existe"}]},{"@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\/2035","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=2035"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/2035\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10297"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=2035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=2035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=2035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}