# information\_schema 系统数据库 information\_schema存储着所有的数据库的相关信息  例： ``` <pre class="calibre17">``` select schema_name from information_schema<span class="token3">.</span>schemata<span class="token3">;</span> select table_name from information_schema<span class="token3">.</span>schemata where table_schema <span class="token1">=</span> <span class="token2">'zzcms'</span><span class="token3">;</span> select column_name from information_schema<span class="token3">.</span>columns where table_schema <span class="token1">=</span> <span class="token2">'zzcms'</span> and <span class="token2">'table_name'</span> <span class="token1">=</span> <span class="token2">'zzcms_zx'</span><span class="token3">;</span> ``` ```