When you create a layer, DB2 Spatial Extender registers it by recording its
identifier and information relating to it in a catalog table. Selected
columns from this table comprise the DB2GSE.GEOMETRY_COLUMNS catalog
view, which is described in Table 35.
Table 35. Columns in the DB2GSE.GEOMETRY_COLUMNS catalog view
| Name | Data Type | Nullable? | Content |
|---|---|---|---|
| LAYER_CATALOG | VARCHAR(30) | Yes | Fully-qualified name of this layer. |
| LAYER_SCHEMA | VARCHAR(30) | No | Schema of the table or view that contains the column that was registered as this layer. |
| LAYER_NAME | VARCHAR(128) | No | Name of the table or view that contains the column that was registered as this layer. |
| LAYER_COLUMN | VARCHAR(30) | No | Name of the column that was registered as this layer. |
| GEOMETRY_TYPE | INTEGER | No | Data type of the column that was registered as this layer. |
| SRID | INTEGER | No | Identifier of the spatial reference system used for the values in the column that was registered as this layer. |
| STORAGE_TYPE | INTEGER | Yes | Information as to how DB2 stores the values in the column that was registered as this layer. For example, data in STORAGE_TYPE might indicate that the values are stored as large objects (LOBs) or as instances of abstract data types (ADTs). |