{"id":1124,"date":"2022-02-25T06:59:00","date_gmt":"2022-02-25T05:59:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1124"},"modified":"2022-12-07T17:35:15","modified_gmt":"2022-12-07T16:35:15","slug":"date-de-modification-d-une-table-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/","title":{"rendered":"Date de modification d&rsquo;une table SQL Server avec une requ\u00eate"},"content":{"rendered":"\n<p>Comment afficher la date de modification d&rsquo;une table SQL Server ? Cet exemple de requ\u00eate SQL permet gr\u00e2ce aux tables syst\u00e8mes de SQL Server de d\u00e9tecter les derniers changements effectu\u00e9s sur une table ou une vue SQL Server. Elle affiche la date de cr\u00e9ation et la date de derni\u00e8re mise \u00e0 jour. Par ailleurs cette requ\u00eate prend en compte uniquement les tables car elle lit les donn\u00e9es depuis la table syst\u00e8me sys.tables.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-comment-afficher-la-date-de-la-derniere-modification-d-une-table-sql-server\">Comment afficher la date de la derni\u00e8re modification d&rsquo;une table SQL Server ?<\/h2>\n\n\n\n<p>En effet, ce script SQL affiche la liste des tables cr\u00e9\u00e9es dans la base. C&rsquo;est \u00e0 dire les tables <em>non-syst\u00e8mes<\/em>, ainsi que la date de cr\u00e9ation et la date de derni\u00e8re mise \u00e0 jour. Par ailleurs la requ\u00eate s\u00e9lectionne les donn\u00e9es dans une <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/relational-databases\/system-tables\/system-tables-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">table syst\u00e8me<\/a>. Noter que les dates correspondent aux changements de structure de la table et non au contenu.<\/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=\"\">SELECT  \n  [name],\n  [type],\n  [type_desc],\n  [create_date],\n  [modify_date]\nFROM    sys.tables\nWHERE   name like '%'\nORDER BY\tmodify_date DESC,\n      create_date DESC;\n  <\/pre>\n\n\n\n<p>Enfin, pour afficher les m\u00eames informations pour une vue, utiliser le m\u00eame code et remplacer <strong>sys.tables<\/strong> par <strong>sys.views<\/strong>. Les tables syst\u00e8mes permettent aussi d&rsquo;afficher <a href=\"https:\/\/expert-only.com\/t-sql\/liste-des-tables-sql-server-avec-une-requete\/\">la liste des toutes les tables dans une base de donn\u00e9es SQL<\/a>.<\/p>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1611235581513\"><strong class=\"schema-faq-question\">Qu&rsquo;est-ce que les tables syst\u00e8mes SQL Server ?<\/strong> <p class=\"schema-faq-answer\">Les tables syst\u00e8mes SQL Server sont des tables utilis\u00e9es par le syst\u00e8me de gestion de base de donn\u00e9es et le moteur SQL. En effet, ces tables stockent la liste des objets SQL Server et permettent \u00e0 la base de donn\u00e9es de fonctionner. Il est fortement recommand\u00e9 de ne pas \u00e9diter ces tables directement.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment afficher la date de modification d&rsquo;une table SQL Server ? Cet exemple de requ\u00eate SQL permet gr\u00e2ce aux tables syst\u00e8mes de SQL Server de d\u00e9tecter les derniers changements effectu\u00e9s sur une table ou une vue SQL Server. Elle <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/\" title=\"Date de modification d&rsquo;une table SQL Server avec une requ\u00eate\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10572,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1124","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>Date de modification d&#039;une table SQL Server - Scripts T-SQL<\/title>\n<meta name=\"description\" content=\"Pour afficher la date de derni\u00e8re modification d&#039;une table SQL Server, \u00e9crire une requ\u00eate sur les tables et vues syst\u00e8mes.\" \/>\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\/date-de-modification-d-une-table-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Date de modification d&#039;une table SQL Server avec une requ\u00eate\" \/>\n<meta property=\"og:description\" content=\"Pour afficher la date de derni\u00e8re modification d&#039;une table SQL Server, \u00e9crire une requ\u00eate sur les tables et vues syst\u00e8mes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-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-02-25T05:59:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-07T16:35:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_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=\"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\/date-de-modification-d-une-table-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Date de modification d&rsquo;une table SQL Server avec une requ\u00eate\",\"datePublished\":\"2022-02-25T05:59:00+00:00\",\"dateModified\":\"2022-12-07T16:35:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/\"},\"wordCount\":285,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/\",\"name\":\"Date de modification d'une table SQL Server - Scripts T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_1920x1080.jpg\",\"datePublished\":\"2022-02-25T05:59:00+00:00\",\"dateModified\":\"2022-12-07T16:35:15+00:00\",\"description\":\"Pour afficher la date de derni\u00e8re modification d'une table SQL Server, \u00e9crire une requ\u00eate sur les tables et vues syst\u00e8mes.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#faq-question-1611235581513\"}],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Date de modification d&rsquo;une table SQL Server avec une requ\u00eate\"}]},{\"@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\"}},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#faq-question-1611235581513\",\"position\":1,\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#faq-question-1611235581513\",\"name\":\"Qu'est-ce que les tables syst\u00e8mes SQL Server ?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Les tables syst\u00e8mes SQL Server sont des tables utilis\u00e9es par le syst\u00e8me de gestion de base de donn\u00e9es et le moteur SQL. En effet, ces tables stockent la liste des objets SQL Server et permettent \u00e0 la base de donn\u00e9es de fonctionner. Il est fortement recommand\u00e9 de ne pas \u00e9diter ces tables directement.\",\"inLanguage\":\"fr-FR\"},\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Date de modification d'une table SQL Server - Scripts T-SQL","description":"Pour afficher la date de derni\u00e8re modification d'une table SQL Server, \u00e9crire une requ\u00eate sur les tables et vues syst\u00e8mes.","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\/date-de-modification-d-une-table-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Date de modification d'une table SQL Server avec une requ\u00eate","og_description":"Pour afficher la date de derni\u00e8re modification d'une table SQL Server, \u00e9crire une requ\u00eate sur les tables et vues syst\u00e8mes.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-02-25T05:59:00+00:00","article_modified_time":"2022-12-07T16:35:15+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Date de modification d&rsquo;une table SQL Server avec une requ\u00eate","datePublished":"2022-02-25T05:59:00+00:00","dateModified":"2022-12-07T16:35:15+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/"},"wordCount":285,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/","name":"Date de modification d'une table SQL Server - Scripts T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_1920x1080.jpg","datePublished":"2022-02-25T05:59:00+00:00","dateModified":"2022-12-07T16:35:15+00:00","description":"Pour afficher la date de derni\u00e8re modification d'une table SQL Server, \u00e9crire une requ\u00eate sur les tables et vues syst\u00e8mes.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#faq-question-1611235581513"}],"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/computer-hard-drive-7CCA596F23D_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Date de modification d&rsquo;une table SQL Server avec une requ\u00eate"}]},{"@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"}},{"@type":"Question","@id":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#faq-question-1611235581513","position":1,"url":"https:\/\/expert-only.com\/fr\/t-sql\/date-de-modification-d-une-table-sql-server\/#faq-question-1611235581513","name":"Qu'est-ce que les tables syst\u00e8mes SQL Server ?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Les tables syst\u00e8mes SQL Server sont des tables utilis\u00e9es par le syst\u00e8me de gestion de base de donn\u00e9es et le moteur SQL. En effet, ces tables stockent la liste des objets SQL Server et permettent \u00e0 la base de donn\u00e9es de fonctionner. Il est fortement recommand\u00e9 de ne pas \u00e9diter ces tables directement.","inLanguage":"fr-FR"},"inLanguage":"fr-FR"}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1124","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=1124"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1124\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10572"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}