WL#8582: INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS

Affects: Server-8.0   —   Status: Complete

General GIS applications need a way to locate geographical data in a database and to inspect the properties of geometry columns, e.g., to display a list to the user with things to plot.

This WL adds the INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS view as specified in SQL/MM Part 3, Sect. 19.2.

The view is backed by INFORMATION_SCHEMA.COLUMNS. The SRS_NAME and SRS_ID columns are always NULL (for now).

User Documentation

Interface INSTR03 INFORMATION_SCHEMA is extended with one more view: INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS.

Add the required columns in the view.

Also add a non-standard extension: The column GEOMETRY_TYPE_NAME specifies the column type, either GEOMETRY or a more specific type. This is similar to the implementation in SQL Anywhere.