<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-st-geometry-columns-table">
      </a>
      28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045078574096">
  </a>
  <p>
   The
   <a class="link" href="information-schema-st-geometry-columns-table.html" title="28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table">
    <code class="literal">
     ST_GEOMETRY_COLUMNS
    </code>
   </a>
   table
      provides information about table columns that store spatial data.
      This table is based on the SQL/MM (ISO/IEC 13249-3) standard, with
      extensions as noted. MySQL implements
   <a class="link" href="information-schema-st-geometry-columns-table.html" title="28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table">
    <code class="literal">
     ST_GEOMETRY_COLUMNS
    </code>
   </a>
   as a view on the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   <a class="link" href="information-schema-columns-table.html" title="28.3.8 The INFORMATION_SCHEMA COLUMNS Table">
    <code class="literal">
     COLUMNS
    </code>
   </a>
   table.
  </p>
  <p>
   The
   <a class="link" href="information-schema-st-geometry-columns-table.html" title="28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table">
    <code class="literal">
     ST_GEOMETRY_COLUMNS
    </code>
   </a>
   table has
      these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_CATALOG
      </code>
     </p>
     <p>
      The name of the catalog to which the table containing the
          column belongs. This value is always
      <code class="literal">
       def
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_SCHEMA
      </code>
     </p>
     <p>
      The name of the schema (database) to which the table
          containing the column belongs.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_NAME
      </code>
     </p>
     <p>
      The name of the table containing the column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COLUMN_NAME
      </code>
     </p>
     <p>
      The name of the column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SRS_NAME
      </code>
     </p>
     <p>
      The spatial reference system (SRS) name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SRS_ID
      </code>
     </p>
     <p>
      The spatial reference system ID (SRID).
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       GEOMETRY_TYPE_NAME
      </code>
     </p>
     <p>
      The column data type. Permitted values are:
      <code class="literal">
       geometry
      </code>
      ,
      <code class="literal">
       point
      </code>
      ,
      <code class="literal">
       linestring
      </code>
      ,
      <code class="literal">
       polygon
      </code>
      ,
      <code class="literal">
       multipoint
      </code>
      ,
      <code class="literal">
       multilinestring
      </code>
      ,
      <code class="literal">
       multipolygon
      </code>
      ,
      <code class="literal">
       geometrycollection
      </code>
      . This column is a MySQL
          extension to the standard.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
