The SYSSPATIAL database contains two tables that provide additional information about columns of type ST_Geometry and the spatial reference systems. These tables follow the definitions provided by the SQL/MM Spatial standard.
|
Table |
Description |
|
GEOMETRY_COLUMNS |
Provides metadata for every table column defined as ST_Geometry. To add geometry metadata to the GEOMETRY_COLUMNS table for a new ST_Geometry column, you can use the SYSSPATIAL.AddGeometryColumn stored procedure. To drop geometry metadata from the GEOMETRY_COLUMNS table, you can use theSYSSPATIAL.DropGeometryColumn stored procedure. |
|
SPATIAL_REF_SYS |
Contains information about each spatial reference system. During installation, the Database Initialization Program (DIP) executes a script that populates the SPATIAL_REF_SYS table. For more information on DIP, see Utilities. |