SPATIAL_REF_SYS

Overview

In 10.6 ES, 10.5 ES:

Lists all geometry columns

In 10.4 ES:

A description for this Information-schema Table has not yet been added to this Documentation.

See also: Information Schema in 10.6 ES, in 10.5 ES, and in 10.4 ES

DETAILS

SCHEMA

CREATE TEMPORARY TABLE `SPATIAL_REF_SYS` (
  `SRID` smallint(5) NOT NULL DEFAULT 0,
  `AUTH_NAME` varchar(512) NOT NULL DEFAULT '',
  `AUTH_SRID` int(5) NOT NULL DEFAULT 0,
  `SRTEXT` varchar(2048) NOT NULL DEFAULT ''
)

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES