{"id":2084,"date":"2022-11-11T07:26:00","date_gmt":"2022-11-11T06:26:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=2084"},"modified":"2022-12-01T09:26:13","modified_gmt":"2022-12-01T08:26:13","slug":"supprimer-une-procedure-stockee-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/","title":{"rendered":"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Comment supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur, si elle existe ?<\/em><\/strong><\/h4>\n\n\n\n<p>Pour supprimer une proc\u00e9dure stock\u00e9e SQL Server et \u00e9viter les erreurs, tester l&rsquo;existence de la proc\u00e9dure dans la base SQL Server pour conditionner la commande DROP PROCEDURE. D&rsquo;autre part, c&rsquo;est une bonne pratique de toujours tester l&rsquo;existence des objets SQL Server. En l\u2019occurrence une proc\u00e9dure stock\u00e9e avec la commande IF EXISTS.<\/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\/supprimer-une-procedure-stockee-sql-server\/#script-pour-supprimer-une-procedure-stockee\" >Script pour supprimer une proc\u00e9dure stock\u00e9e<\/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\/supprimer-une-procedure-stockee-sql-server\/#supprimer-une-procedure-ms-sql-sans-erreur\" >Supprimer une proc\u00e9dure MS SQL sans erreur<\/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\/supprimer-une-procedure-stockee-sql-server\/#test-dexistence-integre-depuis-sql-server-2016\" >Test d&rsquo;existence int\u00e9gr\u00e9 depuis SQL Server 2016<\/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\/supprimer-une-procedure-stockee-sql-server\/#generer-un-script-pour-supprimer-toutes-les-procedures-stockees\" >G\u00e9n\u00e9rer un script pour supprimer toutes les proc\u00e9dures stock\u00e9es<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"script-pour-supprimer-une-procedure-stockee\"><\/span>Script pour supprimer une proc\u00e9dure stock\u00e9e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici la commande T-SQL de base pour supprimer une proc\u00e9dure stock\u00e9e SQL Server:<\/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=\"\">DROP PROCEDURE dbo.uspGetClient;\nGO\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-supprimer-une-procedure-ms-sql-sans-erreur\"><span class=\"ez-toc-section\" id=\"supprimer-une-procedure-ms-sql-sans-erreur\"><\/span>Supprimer une proc\u00e9dure MS SQL sans erreur<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Premi\u00e8rement, comment effacer une proc\u00e9dure stock\u00e9e SQL Server sans g\u00e9n\u00e9rer une erreur ? C&rsquo;est \u00e0 dire v\u00e9rifier si l&rsquo;objet existe avant de le supprimer avec la commande SQL <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/drop-procedure-transact-sql?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">DROP<\/a>. Pour cela, utiliser la fonction T-SQL IF EXISTS. Comme sur cet exemple, sur les versions SQL Server ant\u00e9rieures \u00e0 la version 2016.<\/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\tSELECT \tname \n\tFROM \tsysobjects  \n\tWHERE \tname = 'uspGetClient' \n\tAND \ttype = 'P'\n)\n\tDROP PROCEDURE dbo.uspGetClient;\nGO\n<\/pre>\n\n\n\n<p>En effet, si la proc\u00e9dure n&rsquo;existe pas le message d&rsquo;erreur suivant est affich\u00e9, sur les versions Anglaise de SQL Server:<\/p>\n\n\n\n<p><em>Cannot drop the procedure &lsquo;uspGetClient&rsquo;, because it does not exist or you do not have permission.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"test-dexistence-integre-depuis-sql-server-2016\"><\/span>Test d&rsquo;existence int\u00e9gr\u00e9 depuis SQL Server 2016<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A noter que depuis la version SQL Server 2016, il est possible de tester si une fonction, une table ou une proc\u00e9dure stock\u00e9e existe et la supprimer avec une seule commande SQL.<\/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=\"\">DROP PROCEDURE IF EXISTS dbo.uspGetClient;\nGO\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"generer-un-script-pour-supprimer-toutes-les-procedures-stockees\"><\/span>G\u00e9n\u00e9rer un script pour supprimer toutes les proc\u00e9dures stock\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici enfin une requ\u00eate pour g\u00e9n\u00e9rer un script de type LDD pour supprimer toutes les proc\u00e9d\u00e9es stock\u00e9es de la base de donn\u00e9es. Le code utilise la vue syst\u00e8me <strong><em>sys.procedures<\/em><\/strong>, stock\u00e9e dans la base de donn\u00e9es syst\u00e8me <strong><em>msdb<\/em><\/strong>.<\/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=\"\">SELECT\n  'DROP PROCEDURE IF EXISTS ' + SCHEMA_NAME(schema_id) + '.' + [Name] + ';' AS [SQL_Query], \n  SCHEMA_NAME(schema_id) AS [Schema_Name],\n  [object_id],\n  [type],\n  [type_desc],\n  [create_date]\nFROM sys.procedures\norder by 1;\n<\/pre>\n\n\n\n<p>Le r\u00e9sultat est une colonne avec une ligne pour chaque proc\u00e9dure stock\u00e9e de type utilisateur. Chaque ligne contient une commande pour tester l&rsquo;existence et supprimer la proc\u00e9dure.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"460\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-drop-stored-procedure-script.jpg\" alt=\"G\u00e9n\u00e9rer un script pour supprimer toutes les proc\u00e9dures de la base MS SQL. Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur\" class=\"wp-image-18421\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-drop-stored-procedure-script.jpg 840w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-drop-stored-procedure-script-300x164.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-drop-stored-procedure-script-768x421.jpg 768w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption class=\"wp-element-caption\">G\u00e9n\u00e9rer un script pour supprimer toutes les proc\u00e9dures de la base MS SQL.<\/figcaption><\/figure>\n\n\n\n<p>Pour aller plus loin, toujours sur le sujet des proc\u00e9dures stock\u00e9es, voici un tutoriel SQL Server pour <a href=\"https:\/\/expert-only.com\/t-sql\/modifier-une-procedure-stockee-sql-server\/\">modifier une proc\u00e9dure avec un script T-SQL<\/a>. De plus, voici un <a href=\"https:\/\/expert-only.com\/t-sql\/creer-fonction-sql-server-avec-un-script\/\">exemple de script pour cr\u00e9er une fonction SQL<\/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=\"pColPZWc3h\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/\">Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ?<\/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\u00a0Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ?\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/embed\/#?secret=9RtWizRClg#?secret=pColPZWc3h\" data-secret=\"pColPZWc3h\" 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 supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur, si elle existe ? Pour supprimer une proc\u00e9dure stock\u00e9e SQL Server et \u00e9viter les erreurs, tester l&rsquo;existence de la proc\u00e9dure dans la base SQL Server pour conditionner la commande DROP <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/\" title=\"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10872,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-2084","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>Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur - T-SQL<\/title>\n<meta name=\"description\" content=\"Pour supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur, tester d&#039;abord l&#039;existence de l&#039;objet dans la base avec ce script 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\/supprimer-une-procedure-stockee-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur\" \/>\n<meta property=\"og:description\" content=\"Pour supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur, tester d&#039;abord l&#039;existence de l&#039;objet dans la base avec ce script T-SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-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-11T06:26:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-01T08:26:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_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=\"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\/supprimer-une-procedure-stockee-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur\",\"datePublished\":\"2022-11-11T06:26:00+00:00\",\"dateModified\":\"2022-12-01T08:26:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/\"},\"wordCount\":407,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/\",\"name\":\"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"datePublished\":\"2022-11-11T06:26:00+00:00\",\"dateModified\":\"2022-12-01T08:26:13+00:00\",\"description\":\"Pour supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur, tester d'abord l'existence de l'objet dans la base avec ce script T-SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur\"}]},{\"@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":"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur - T-SQL","description":"Pour supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur, tester d'abord l'existence de l'objet dans la base avec ce script 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\/supprimer-une-procedure-stockee-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur","og_description":"Pour supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur, tester d'abord l'existence de l'objet dans la base avec ce script T-SQL.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-11T06:26:00+00:00","article_modified_time":"2022-12-01T08:26:13+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur","datePublished":"2022-11-11T06:26:00+00:00","dateModified":"2022-12-01T08:26:13+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/"},"wordCount":407,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/","name":"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","datePublished":"2022-11-11T06:26:00+00:00","dateModified":"2022-12-01T08:26:13+00:00","description":"Pour supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur, tester d'abord l'existence de l'objet dans la base avec ce script T-SQL.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur"}]},{"@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\/2084","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=2084"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/2084\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10872"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=2084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=2084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=2084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}