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
ST_GEOMETRY_COLUMNS as a view on the
ST_GEOMETRY_COLUMNS table has
The name of the catalog to which the table containing the column belongs. This value is always
The name of the schema (database) to which the table containing the column belongs.
The name of the table containing the column.
The name of the column.
The spatial reference system (SRS) name.
The spatial reference system ID (SRID).
The column data type. Permitted values are:
geometrycollection. This column is a MySQL extension to the standard.