Purpose
The information_schema.ST_GEOMETRY_COLUMNS view displays tables with spatial data columns and spatial data types.
Note
This view is introduced since OceanBase Database V3.2.4.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_SCHEMA | varchar(128) | NO | The database to which the column belongs. |
| TABLE_NAME | varchar(256) | NO | The name of the table that contains the spatial column. |
| COLUMN_NAME | varchar(128) | NO | The name of the column. |
| SRS_NAME | varchar(128) | NO | The name of the spatial coordinate system. |
| SRS_ID | bigint(20) unsigned | NO | The ID of the spatial coordinate system. |
| GEOMETRY_TYPE_NAME | varchar(15) | NO | The spatial data type. |