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.
If a spatial column was registered in association with a spatial reference system, you can also use the view to find out the spatial reference system's name and numeric identifier. For additional information about spatial columns, query DB2's SYSCAT.COLUMN catalog view.
If a spatial column was registered in association with a spatial reference system, and compute_extents was specified, you can also use this view to query information about the geographic extents for the spatial column and the date when they were last computed.
Name | Data type | Nullable? | Content |
---|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | No | Name of the schema to which the table that contains this spatial column belongs. |
TABLE_NAME | VARCHAR(128) | No | Unqualified name of the table that contains this spatial column. |
COLUMN_NAME | VARCHAR(128) | No | Name of this spatial column. The combination of TABLE_SCHEMA, TABLE_NAME, and COLUMN_NAME uniquely identifies the column. |
TYPE_SCHEMA | VARCHAR(128) | No | Name of the schema to which the declared data type of this spatial column belongs. This name is obtained from the DB2® catalog. |
TYPE_NAME | VARCHAR(128) | No | Unqualified name of the declared data type of this spatial column. This name is obtained from the DB2 catalog. |
SRS_NAME | VARCHAR(128) | Yes | Name of the spatial reference system that is associated with this spatial column. If no spatial reference system is associated with the column, then SRS_NAME is null. |
SRS_ID | INTEGER | Yes | Numeric identifier of the spatial reference system that is associated with this spatial column. If no spatial reference system is associated with the column, then SRS_ID is null. |
MIN_X | DOUBLE | Yes | Minimum x value of all spatial values in the column. |
MIN_Y | DOUBLE | Yes | Minimum y value of all spatial values in the column. |
MIN_Z | DOUBLE | Yes | Minimum z value of all spatial values in the column. |
MAX_X | DOUBLE | Yes | Maximum x value of all spatial values in the column. |
MAX_Y | DOUBLE | Yes | Maximum y value of all spatial values in the column. |
MAX_Z | DOUBLE | Yes | Maximum z value of all spatial values in the column. |
MIN_M | DOUBLE | Yes | Minimum m value of all spatial values in the column. |
MAX_M | DOUBLE | Yes | Maximum m value of all spatial values in the column. |
EXTENT_TIME | TIMESTAMP | Yes | Timestamp of when the extents were last computed. |