SQL/MM Spatial defines two tables (or views) that provide additional information about columns of type ST_Geometry and the spatial reference systems.
| Table | Description |
|---|---|
| GEOMETRY_COLUMNS Table | Provides metadata for every table column defined as ST_Geometry. Teradata provides stored procedures to add and drop geometry metadata in this table. For more information on these procedures, see AddGeometryColumn Stored Procedure, AddGeometryColumn_3D Stored Procedure, and DropGeometryColumn Stored Procedure |
| SPATIAL_REF_SYS Table | Contains information about each spatial reference system. During installation, the Database Initialization Program (DIP) utility executes a script that populates the SPATIAL_REF_SYS table. For more information on DIP, see Teradata Vantage™ - Database Utilities, B035-1102. |
The GEOMETRY_COLUMNS and SPATIAL_REF_SYS tables and associated stored procedures are defined in the SYSSPATIAL database.
For more information , see Geospatial Metadata (SYSSPATIAL Database).