{"id":30294,"date":"2024-02-12T06:45:00","date_gmt":"2024-02-12T05:45:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=30294"},"modified":"2025-10-22T16:21:47","modified_gmt":"2025-10-22T14:21:47","slug":"comment-obtenir-la-liste-des-tables-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/","title":{"rendered":"Comment Afficher la Liste des Tables SQL Server ?"},"content":{"rendered":"\n<p class=\"has-text-align-center\"><strong><em>3 exemples de requ\u00eates pour afficher la liste des tables dans une base SQL Server.<\/em><\/strong><\/p>\n\n\n\n<p>Pour auditer une base de donn\u00e9es SQL Server, \u00e9tablir une liste des tables est une \u00e9tape importante, voire obligatoire. Il est courant de vouloir cette liste sous forme de tableau ou de feuille Excel.<\/p>\n\n\n\n<p>Cette requ\u00eate SQL permet de lister toutes les tables d&rsquo;une base de donn\u00e9es SQL Server et d&rsquo;afficher le nombre de lignes et la taille pour chaque table. Les d\u00e9veloppeurs SQL Server cherchent \u00e9galement souvent des tables, par exemple pour une analyse d&rsquo;impact.<\/p>\n\n\n\n<p>Il est donc utile de lister rapidement toutes les tables pour un audit technique, fonctionnel ou encore r\u00e9glementaire. Pour commencer, ces 3 diff\u00e9rentes requ\u00eates T-SQL permettent d&rsquo;afficher les informations de diff\u00e9rentes mani\u00e8res, et avec diff\u00e9rents niveaux de d\u00e9tails.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>La premi\u00e8re est une simple liste des tables. <\/li>\n\n\n\n<li>La deuxi\u00e8me requ\u00eate affiche des informations telles que les colonnes object_id, create_date et modify_date.<\/li>\n\n\n\n<li>Enfin, la troisi\u00e8me affiche le sch\u00e9ma, le nombre de lignes et l&rsquo;espace disque utilis\u00e9 par chaque table.<\/li>\n<\/ol>\n\n\n\n<p>En effet, les tables syst\u00e8me SQL Server et <a href=\"https:\/\/ec.europa.eu\/eurostat\/fr\/web\/metadata\" target=\"_blank\" rel=\"noreferrer noopener\">les vues syst\u00e8me contiennent des m\u00e9tadonn\u00e9es<\/a> qui d\u00e9crivent les diff\u00e9rents objets dans la base de donn\u00e9es. Ainsi, toutes les solutions pr\u00e9sent\u00e9es dans cet article utilisent des tables ou des vues syst\u00e8me, telles que :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>information_schema.tables<\/li>\n\n\n\n<li>sys.tables<\/li>\n\n\n\n<li>sys.indexes<\/li>\n\n\n\n<li>sys.partitions<\/li>\n\n\n\n<li>sys.allocation_units<\/li>\n\n\n\n<li>ou sys.schemas<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-afficher-une-liste-de-toutes-les-tables-avec-une-seule-requete\">1. Afficher une liste de toutes les tables avec une seule requ\u00eate<\/h2>\n\n\n\n<p><strong>Dans SQL Server, information_schema.table est une vue, pas une table. <\/strong>C&rsquo;est l&rsquo;une des vues INFORMATION_SCHEMA standardis\u00e9es par l&rsquo;<a href=\"https:\/\/www.iso.org\/fr\/ics\/35.100\/x\/\" target=\"_blank\" rel=\"noreferrer noopener\">ISO<\/a> pour les syst\u00e8mes de gestion de bases de donn\u00e9es relationnelles (<a href=\"https:\/\/expert-only.com\/fr\/concepts\/sgbd-systeme-gestion-de-base-de-donnees\/\">SGBDR<\/a>).<\/p>\n\n\n\n<p>Cette vue fournit des informations sur les tables et les vues pr\u00e9sentes dans une base de donn\u00e9es. Par exemple, vous pouvez simplement utiliser la table syst\u00e8me <strong><em>information_schema.table<\/em><\/strong>, comme ceci :<\/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 *\nFROM   information_schema.tables\nWHERE  table_type='BASE TABLE';\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"560\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/02\/T-SQL-list-all-tables-in-sql-server-database.jpg\" alt=\"Requ\u00eate pour obtenir la liste de toutes les tables dans SQL Server\" class=\"wp-image-30285\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/02\/T-SQL-list-all-tables-in-sql-server-database.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2024\/02\/T-SQL-list-all-tables-in-sql-server-database-300x280.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><em>Requ\u00eate pour obtenir la liste de toutes les tables dans SQL Server<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-requete-sql-server-pour-lister-les-objets-avec-sys-tables\">2. Requ\u00eate SQL Server pour lister les objets avec sys.tables<\/h2>\n\n\n\n<p>Vous pouvez \u00e9galement utiliser la table syst\u00e8me sys.tables. Le r\u00e9sultat de la requ\u00eate montre que le type de table stock\u00e9e dans la colonne <strong><em>type_desc<\/em><\/strong> est USER_TABLE.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><strong>Sys.tables en Transact-SQL est \u00e9galement une vue syst\u00e8me et non une table.<\/strong><\/p>\n\n\n\n<p>Elle fait partie du catalogue syst\u00e8me SQL Server et fournit des informations sur toutes les tables utilisateur et les tables syst\u00e8me existantes dans une base. Elle peut \u00eatre utilis\u00e9e pour r\u00e9cup\u00e9rer divers d\u00e9tails et m\u00e9tadonn\u00e9es sur les tables, tels que leur nom, date de cr\u00e9ation, date de modification, etc. <\/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 *\nFROM   sys.tables;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-afficher-la-liste-des-noms-de-tables-et-leur-tailles-en-t-sql\">3. Afficher la liste des noms de tables et leur tailles en T-SQL<\/h2>\n\n\n\n<p>La troisi\u00e8me solution, beaucoup plus compl\u00e8te, consiste \u00e0 utiliser plusieurs tables syst\u00e8me SQL Server telles que : sys.tables, sys.indexes, sys.partitions, sys.allocation_units et sys.schemas.<\/p>\n\n\n\n<p>Ces 5 tables permettent d&rsquo;afficher le nombre de lignes dans chaque table et l&rsquo;espace disque utilis\u00e9. Par exemple, cette requ\u00eate affiche toutes les tables avec leur nombre de lignes tri\u00e9es par ordre d\u00e9croissant.<\/p>\n\n\n\n<p><strong><em>Cette requ\u00eate est utile pour trouver la taille des plus grandes tables dans une base de donn\u00e9es SQL Server.<\/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\tsch.name AS SCHEMANAME,\n\ttab.name AS TABLENAME,\n\tpar.rows AS ROWCOUNTS,\n\tSUM(alc.total_pages) * 8 AS TOTAL_SPACE,\n\tSUM(alc.used_pages) * 8 AS USED_SPACE,\n\t(SUM(alc.total_pages) - SUM(alc.used_pages)) * 8 AS UNUSED_SPACE\nFROM sys.tables tab\n\tINNER JOIN sys.indexes ind\n\t\tON tab.object_id = ind.object_id\n\tINNER JOIN sys.partitions par\n\t\tON  ind.object_id = par.object_id\n\t\tAND ind.index_id = par.index_id\n\tINNER JOIN sys.allocation_units alc\n\t\tON par.partition_id = alc.container_id\n\tLEFT OUTER JOIN sys.schemas sch\n\t\tON tab.schema_id = sch.schema_id\nGROUP BY \ttab.name, \n\t\tsch.name, \n\t\tpar.rows\nORDER BY par.rows DESC;\n<\/pre>\n\n\n\n<p>Cette liste de points explique la requ\u00eate ci-dessus et comment elle est construite.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le mot-cl\u00e9 \u00ab\u00a0ORDER BY par.rows DESC;\u00a0\u00bb est utilis\u00e9 pour trier la liste des tables SQL Server par leur nombre de lignes, dans un ordre d\u00e9croissant.<\/li>\n\n\n\n<li>Pour trier par sch\u00e9ma puis par nom de table, utilisez \u00ab\u00a0ORDER BY 1,2\u00a0\u00bb ou \u00ab\u00a0ORDER BY sch.name, tab.name;\u00a0\u00bb. <\/li>\n\n\n\n<li>La taille des tables est not\u00e9e en KiloOctets ou Ko.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-a-propos-des-objets-sql-server-et-des-tables-systemes\">A propos des objets SQL Server et des tables syst\u00e8mes<\/h3>\n\n\n\n<p>Ce court tutoriel technique sur SQL Server propose 3 requ\u00eates pour lister toutes les tables dans une base de donn\u00e9es. Si vous \u00eates encore nouveau sur SQL Server et souhaitez cr\u00e9er une table, voici <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/\">comment cr\u00e9er une table SQL Server<\/a> et ins\u00e9rer quelques lignes de donn\u00e9es.<\/p>\n\n\n\n<p>Pour aller plus loin, il est possible d&rsquo;afficher une <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/\">liste de tables MS SQL avec plus d&rsquo;accent sur l&rsquo;espace disque disponible<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter 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=\"P7siprk4wg\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/\">Afficher la taille des tables SQL Server sur le disque<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Afficher la taille des tables SQL Server sur le disque&#8221; &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/taille-tables-sql-server-espace-disque\/embed\/#?secret=HJb7aQYXzn#?secret=P7siprk4wg\" data-secret=\"P7siprk4wg\" 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>3 exemples de requ\u00eates pour afficher la liste des tables dans une base SQL Server. Pour auditer une base de donn\u00e9es SQL Server, \u00e9tablir une liste des tables est une \u00e9tape importante, voire obligatoire. Il est courant de vouloir <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/\" title=\"Comment Afficher la Liste des Tables SQL Server ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":26332,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-30294","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>Comment Afficher la Liste des Tables SQL Server ? T-SQL<\/title>\n<meta name=\"description\" content=\"Requ\u00eate pour afficher la liste des tables SQL Server dans une base de donn\u00e9es et leur attributs comme le nombre de lignes et la taille.\" \/>\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\/comment-obtenir-la-liste-des-tables-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment Afficher la Liste des Tables SQL Server ?\" \/>\n<meta property=\"og:description\" content=\"Requ\u00eate pour afficher la liste des tables SQL Server dans une base de donn\u00e9es et leur attributs comme le nombre de lignes et la taille.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-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=\"2024-02-12T05:45:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-22T14:21:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg\" \/>\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\/comment-obtenir-la-liste-des-tables-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment Afficher la Liste des Tables SQL Server ?\",\"datePublished\":\"2024-02-12T05:45:00+00:00\",\"dateModified\":\"2025-10-22T14:21:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/\"},\"wordCount\":742,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/\",\"name\":\"Comment Afficher la Liste des Tables SQL Server ? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg\",\"datePublished\":\"2024-02-12T05:45:00+00:00\",\"dateModified\":\"2025-10-22T14:21:47+00:00\",\"description\":\"Requ\u00eate pour afficher la liste des tables SQL Server dans une base de donn\u00e9es et leur attributs comme le nombre de lignes et la taille.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment Afficher la Liste des Tables SQL Server ?\"}]},{\"@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":"Comment Afficher la Liste des Tables SQL Server ? T-SQL","description":"Requ\u00eate pour afficher la liste des tables SQL Server dans une base de donn\u00e9es et leur attributs comme le nombre de lignes et la taille.","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\/comment-obtenir-la-liste-des-tables-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment Afficher la Liste des Tables SQL Server ?","og_description":"Requ\u00eate pour afficher la liste des tables SQL Server dans une base de donn\u00e9es et leur attributs comme le nombre de lignes et la taille.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-02-12T05:45:00+00:00","article_modified_time":"2025-10-22T14:21:47+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg","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\/comment-obtenir-la-liste-des-tables-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment Afficher la Liste des Tables SQL Server ?","datePublished":"2024-02-12T05:45:00+00:00","dateModified":"2025-10-22T14:21:47+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/"},"wordCount":742,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/","name":"Comment Afficher la Liste des Tables SQL Server ? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg","datePublished":"2024-02-12T05:45:00+00:00","dateModified":"2025-10-22T14:21:47+00:00","description":"Requ\u00eate pour afficher la liste des tables SQL Server dans une base de donn\u00e9es et leur attributs comme le nombre de lignes et la taille.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-obtenir-la-liste-des-tables-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment Afficher la Liste des Tables SQL Server ?"}]},{"@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\/30294","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=30294"}],"version-history":[{"count":5,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/30294\/revisions"}],"predecessor-version":[{"id":31065,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/30294\/revisions\/31065"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/26332"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=30294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=30294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=30294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}