{"id":409,"date":"2011-04-29T14:02:26","date_gmt":"2011-04-29T12:02:26","guid":{"rendered":"http:\/\/www.capri-soft.de\/blog\/?p=409"},"modified":"2011-08-09T15:54:28","modified_gmt":"2011-08-09T13:54:28","slug":"ms-sql-server-drop-table-wenn-die-tabelle-nicht-existiert","status":"publish","type":"post","link":"https:\/\/www.capri-soft.de\/blog\/?p=409","title":{"rendered":"MS SQL Server: DROP TABLE wenn die Tabelle nicht existiert"},"content":{"rendered":"<h1>Aufgabenstellung<\/h1>\n<p>Eine Tabelle soll gel\u00f6scht werden wenn sie existiert.<\/p>\n<h1>Problem<\/h1>\n<p>Nutzt man in einem TSQL-Skript den DROP Table Befehl (z.B. in einer Stored Procedure) erh\u00e4lt man eine Fehlermeldung, das die zu l\u00f6schende Tabelle nicht existiert. In einigen F\u00e4llen f\u00fchrt dies zum Abbruch des Skriptes. <\/p>\n<h1>Ansatz<\/h1>\n<p>\u00dcber das META-Schema vom MS SQL Server l\u00e4sst sich erfragen, ob eine Tabelle existiert. <\/p>\n<h1>L\u00f6sung<\/h1>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nIF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = &#039;users&#039;) \r\nDROP TABLE users;\r\n<\/pre>\n<iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=https%3A%2F%2Fwww.capri-soft.de%2Fblog%2F%3Fp%3D409&amp;layout=standard&amp;show_faces=true&amp;width=450&amp;action=like&amp;colorscheme=light\" scrolling=\"no\" frameborder=\"0\" allowTransparency=\"true\" style=\"border:none; overflow:hidden; width:450px;margin-top:5px;\"><\/iframe>","protected":false},"excerpt":{"rendered":"<p>Aufgabenstellung Eine Tabelle soll gel\u00f6scht werden wenn sie existiert. Problem Nutzt man in einem TSQL-Skript den DROP Table Befehl (z.B. in einer Stored Procedure) erh\u00e4lt man eine Fehlermeldung, das die zu l\u00f6schende Tabelle nicht existiert. In einigen F\u00e4llen f\u00fchrt dies zum Abbruch des Skriptes. Ansatz \u00dcber das META-Schema vom MS SQL Server l\u00e4sst sich erfragen, &hellip; <a href=\"https:\/\/www.capri-soft.de\/blog\/?p=409\" class=\"more-link\"><span class=\"screen-reader-text\">MS SQL Server: DROP TABLE wenn die Tabelle nicht existiert<\/span> weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[11],"tags":[],"class_list":["post-409","post","type-post","status-publish","format-standard","hentry","category-ms-sql-server"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4yGeN-6B","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=409"}],"version-history":[{"count":3,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/409\/revisions"}],"predecessor-version":[{"id":468,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/409\/revisions\/468"}],"wp:attachment":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}