Note
This view is available starting with V3.2.4.
Overview
Displays tables that contain spatial data columns and spatial data types.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| TABLE_SCHEMA | varchar(128) | NO | Database to Which Column Belongs |
| TABLE_NAME | varchar(256) | NO | Table name containing the spatial column |
| COLUMN_NAME | varchar(128) | NO | Column name |
| SRS_NAME | varchar(128) | NO | Spatial Coordinate System Name |
| SRS_ID | bigint(20) unsigned | NO | Spatial Coordinate System ID |
| GEOMETRY_TYPE_NAME | varchar(15) | NO | The spatial data type. |