MySQL :: MySQL 8.4 Reference Manual :: 28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY

version 8.4

8.0 current

8.0 Japanese

MySQL 8.4 Reference Manual / ... / The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table

28.3.35 INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS 表

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.

PREV HOME UP NEXT