{"id":1958,"date":"2022-05-16T06:03:00","date_gmt":"2022-05-16T04:03:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=1958"},"modified":"2022-07-13T12:14:21","modified_gmt":"2022-07-13T10:14:21","slug":"vider-table-sql-server-truncate-table","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/","title":{"rendered":"Vider une table SQL Server (Truncate Table)"},"content":{"rendered":"\n

Comment vider toutes les donn\u00e9es d’une table SQL Server avec une requ\u00eate ? Depuis SSMS, se connecter \u00e0 la base SQL Server et utiliser la commande TRUNCATE TABLE pour vider les donn\u00e9es de la table. <\/p>\n\n\n\n

Noter que ls commande TRUNCATE est diff\u00e9rente de la requ\u00eate DELETE car toutes les donn\u00e9es sont supprim\u00e9es sans aucun filtre. La commande TRUNCATE est donc plus rapide et recommand\u00e9e.<\/p>\n\n\n\n

Vider une table SQL Server avec la requ\u00eate Truncate Table<\/h2>\n\n\n\n

Cette commande supprime toutes les donn\u00e9es stock\u00e9es dans la table. Attention cette commande est irr\u00e9versible. Penser \u00e0 v\u00e9rifier vos sauvegardes de bases de donn\u00e9es pour ne pas perdre de donn\u00e9es.<\/p>\n\n\n\n

Noter que cette action est irr\u00e9versible. <\/mark><\/strong><\/p>\n\n\n\n

Utiliser simplement une requ\u00eate T-SQL depuis SQL Server Management Studio<\/a><\/strong>, avec la commande TRUNCATE TABLE. <\/p>\n\n\n\n

Noter que la requ\u00eate TRUNCATE est diff\u00e9rente<\/a> de la commande DELETE surtout en termes de performances. En effet, une commande du type DELETE FROM scan toutes les lignes avant de supprimer et permet de filtrer les lignes \u00e0 supprimer.<\/p>\n\n\n\n

TRUNCATE TABLE [dbo].[VENTES];\nGO\n<\/pre>\n\n\n\n
Droits minimum n\u00e9cessaires sur la table pour ex\u00e9cuter un TRUNCATE<\/h3>\n\n\n\n
La commande TRUNCATE a plus d’impact qu’un simple DELETE, notamment car le truncate ne peut pas \u00eatre annul\u00e9 via le journal des transactions<\/a><\/strong>. Le droit minimum pour ex\u00e9cuter une commande TRUNCATE est ALTER. Car le SGBD consid\u00e8re que c’est une modification de la table.<\/p>\n\n\n\n
Pour supprimer la table compl\u00e8tement il faut supprimer la structure des donn\u00e9es et les donn\u00e9es. Pour \u00e9viter de g\u00e9n\u00e9rer des messages d’erreur, alors tester au pr\u00e9alable l’existence de la table SQL Server avant de la supprimer<\/a>.<\/p>\n\n\n\n
\nhttps:\/\/expert-only.com\/tables\/tester-table-sql-server-existe-avant-supprimer\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"
Comment vider toutes les donn\u00e9es d’une table SQL Server avec une requ\u00eate ? Depuis SSMS, se connecter \u00e0 la base SQL Server et utiliser la commande TRUNCATE TABLE pour vider les donn\u00e9es de la table. Noter que ls commande …<\/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-1958","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-t-sql"},"yoast_head":"\nVider une table SQL Server (Truncate Table) - T-SQL<\/title>\n<meta name=\"description\" content=\"Exemple de script pour vider les donn\u00e9es d'une table SQL Server avec la commande Truncate Table sans utiliser de filtre.\" \/>\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\/vider-table-sql-server-truncate-table\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Vider une table SQL Server (Truncate Table)\" \/>\n<meta property=\"og:description\" content=\"Exemple de script pour vider les donn\u00e9es d'une table SQL Server avec la commande Truncate Table sans utiliser de filtre.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/\" \/>\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-05-16T04:03:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-13T10:14:21+00:00\" \/>\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=\"2 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\/vider-table-sql-server-truncate-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Vider une table SQL Server (Truncate Table)\",\"datePublished\":\"2022-05-16T04:03:00+00:00\",\"dateModified\":\"2022-07-13T10:14:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/\"},\"wordCount\":298,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/\",\"name\":\"Vider une table SQL Server (Truncate Table) - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"datePublished\":\"2022-05-16T04:03:00+00:00\",\"dateModified\":\"2022-07-13T10:14:21+00:00\",\"description\":\"Exemple de script pour vider les donn\u00e9es d'une table SQL Server avec la commande Truncate Table sans utiliser de filtre.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vider une table SQL Server (Truncate 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":"Vider une table SQL Server (Truncate Table) - T-SQL","description":"Exemple de script pour vider les donn\u00e9es d'une table SQL Server avec la commande Truncate Table sans utiliser de filtre.","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\/vider-table-sql-server-truncate-table\/","og_locale":"fr_FR","og_type":"article","og_title":"Vider une table SQL Server (Truncate Table)","og_description":"Exemple de script pour vider les donn\u00e9es d'une table SQL Server avec la commande Truncate Table sans utiliser de filtre.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-05-16T04:03:00+00:00","article_modified_time":"2022-07-13T10:14:21+00:00","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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Vider une table SQL Server (Truncate Table)","datePublished":"2022-05-16T04:03:00+00:00","dateModified":"2022-07-13T10:14:21+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/"},"wordCount":298,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/","name":"Vider une table SQL Server (Truncate Table) - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"datePublished":"2022-05-16T04:03:00+00:00","dateModified":"2022-07-13T10:14:21+00:00","description":"Exemple de script pour vider les donn\u00e9es d'une table SQL Server avec la commande Truncate Table sans utiliser de filtre.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/vider-table-sql-server-truncate-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Vider une table SQL Server (Truncate 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\/1958","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=1958"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1958\/revisions"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}