{"id":334,"date":"2025-10-08T14:34:16","date_gmt":"2025-10-08T14:34:16","guid":{"rendered":"https:\/\/fhix.fr\/?p=334"},"modified":"2026-04-07T09:57:05","modified_gmt":"2026-04-07T09:57:05","slug":"lister-les-bibliotheques-les-tables-et-les-colonnes-avec-sql","status":"publish","type":"post","link":"https:\/\/fhix.fr\/index.php\/2025\/10\/08\/lister-les-bibliotheques-les-tables-et-les-colonnes-avec-sql\/","title":{"rendered":"Lister les biblioth\u00e8ques, les tables et les colonnes avec SQL"},"content":{"rendered":"\n<p><strong><mark style=\"background-color:var(--base-3)\" class=\"has-inline-color has-accent-color\">Lister les biblioth\u00e8ques :<\/mark><\/strong><br><code><strong>SELECT<\/strong> * <strong>FROM<\/strong> sysschemas<\/code><br><br>Par exemple, les 10 plus grosses biblioth\u00e8ques :<br><code><strong>SELECT<\/strong> * <strong>FROM<\/strong> sysschemas <br><strong>ORDER BY<\/strong> schema_size <strong>DESC<\/strong><br><strong>LIMIT<\/strong> 10<\/code><br><\/p>\n\n\n\n<p><strong><mark style=\"background-color:var(--base-3)\" class=\"has-inline-color has-accent-color\">Lister les tables : <\/mark><\/strong><br><code><strong>SELECT<\/strong> * <strong>FROM<\/strong> systables<\/code><\/p>\n\n\n\n<p>Par exemple, lister les tables d&rsquo;une biblioth\u00e8que :<br><code><strong>SELECT<\/strong> * <strong>FROM<\/strong> systables <\/code><br><code><strong>WHERE<\/strong> table_schema ='maBib'<\/code><br><br><br><strong><mark style=\"background-color:var(--base-3)\" class=\"has-inline-color has-accent-color\">Lister les colonnes :<\/mark><\/strong><br><code><strong>SELECT<\/strong> * <strong>FROM<\/strong> syscolumns<\/code><br><br>Lister les colonnes d&rsquo;une table :<br><code><strong>SELECT<\/strong> * <strong>FROM<\/strong> syscolumns <br><strong>WHERE<\/strong> table_name='maTable' <strong>AND<\/strong> table_schema='maBib'<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lister les biblioth\u00e8ques :SELECT * FROM sysschemas Par exemple, les 10 plus grosses biblioth\u00e8ques :SELECT * FROM sysschemas ORDER BY schema_size DESCLIMIT 10 Lister les tables : SELECT * FROM systables Par exemple, lister les tables d&rsquo;une biblioth\u00e8que :SELECT * FROM systables WHERE table_schema =&rsquo;maBib&rsquo; Lister les colonnes :SELECT * FROM syscolumns Lister les colonnes &#8230; <a title=\"Lister les biblioth\u00e8ques, les tables et les colonnes avec SQL\" class=\"read-more\" href=\"https:\/\/fhix.fr\/index.php\/2025\/10\/08\/lister-les-bibliotheques-les-tables-et-les-colonnes-avec-sql\/\" aria-label=\"En savoir plus sur Lister les biblioth\u00e8ques, les tables et les colonnes avec SQL\">Lire la suite<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-334","post","type-post","status-publish","format-standard","hentry","category-sql-system"],"_links":{"self":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/comments?post=334"}],"version-history":[{"count":13,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/334\/revisions"}],"predecessor-version":[{"id":349,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/posts\/334\/revisions\/349"}],"wp:attachment":[{"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/media?parent=334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/categories?post=334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fhix.fr\/index.php\/wp-json\/wp\/v2\/tags?post=334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}