28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table

The ST_GEOMETRY_COLUMNS 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 ST_GEOMETRY_COLUMNS as a view on the INFORMATION_SCHEMA COLUMNS table.

The ST_GEOMETRY_COLUMNS table has these columns:

  • TABLE_CATALOG

The name of the catalog to which the table containing the column belongs. This value is always def. - TABLE_SCHEMA

The name of the schema (database) to which the table containing the column belongs. - TABLE_NAME

The name of the table containing the column. - COLUMN_NAME

The name of the column. - SRS_NAME

The spatial reference system (SRS) name. - SRS_ID

The spatial reference system ID (SRID). - GEOMETRY_TYPE_NAME

The column data type. Permitted values are: geometry, point, linestring, polygon, multipoint, multilinestring, multipolygon, geometrycollection. This column is a MySQL extension to the standard.