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.
|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.