Name

Probe_Geometry_Columns — Explores all tables with Jaspa geometry constraints and adds them to the metadata table GEOMETRY_COLUMNS if they are not already there.

Synopsis

varchar Probe_Geometry_Columns();

Description

Explores all tables with Jaspa geometry constraints and adds them to the metadata table GEOMETRY_COLUMNS if they are not already there.

Coordinate Dimensions
2D3DM

-

-

-

Spatial Standards Support
OGC SFS for SQL. 1.1 (1999)OGC SFS for SQL. 1.1.0 (2005)OGC SFS for SQL. 1.2.0 (2006)SQL-MM Part 3
----

Examples

SELECT Probe_Geometry_Columns();

                    probe_geometry_columns                     
---------------------------------------------------------------
 The method has added 5 new rows to the geometry columns table
(1 row)

Related functions

AddGeometryColumn