Catalog views

Use catalog views for Db2® Spatial Extender to obtain useful information about your spatial data.

DB2GSE.ST_COORDINATE_SYSTEMS catalog view
Use the DB2GSE.ST_COORDINATE_SYSTEMS catalog view to retrieve information about registered coordinate systems.
DB2GSE.ST_GEOMETRY_COLUMNS catalog view
Use the DB2GSE.ST_GEOMETRY_COLUMNS catalog view to find information about all spatial columns in all tables that contain spatial data in the database.
DB2GSE.ST_SIZINGS catalog view
Use the DB2GSE.ST_SIZINGS catalog view to retrieve information about supported variables and their maximum length.
DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view
Use the DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view to retrieve information about registered spatial reference systems.
DB2GSE.ST_UNITS_OF_MEASURE catalog view
Use the DB2GSE.ST_UNITS_OF_MEASURE catalog view to determine what units of measure you can choose from.

Parent topic: Db2 Spatial Extender