Provides metadata for every table column defined as ST_Geometry.
CREATE TABLE SYSSPATIAL.GEOMETRY_COLUMNS, FALLBACK
(
F_TABLE_CATALOG CHARACTER VARYING(256) CHARACTER SET LATIN NOT NULL,
F_TABLE_SCHEMA CHARACTER VARYING(128) CHARACTER SET UNICODE NOT NULL,
F_TABLE_NAME CHARACTER VARYING(128) CHARACTER SET UNICODE NOT NULL,
F_GEOMETRY_COLUMN CHARACTER VARYING(128)
CHARACTER SET UNICODE NOT NULL,
COORD_DIMENSION INTEGER,
SRID INTEGER REFERENCES SPATIAL_REF_SYS,
GEOM_TYPE CHARACTER VARYING(30) CHARACTER SET LATIN NOT NULL,
UxMin FLOAT,
UyMin FLOAT,
UxMax FLOAT,
UyMax FLOAT,
CONSTRAINT GC_PK PRIMARY KEY
(F_TABLE_CATALOG, F_TABLE_SCHEMA, F_TABLE_NAME, F_GEOMETRY_COLUMN)
);
|
Column |
Description |
|
|
F_TABLE_CATALOG |
Catalog name (can be "" for Teradata). |
|
|
F_TABLE_SCHEMA |
Database name. |
|
|
F_TABLE_NAME |
Table name. |
|
|
F_GEOMETRY_COLUMN |
Column name that is declared as ST_Geometry. |
|
|
COORD_DIMENSION |
Number of coordinates used in the ST_Geometry values, usually corresponding to the number of dimensions in the spatial reference system. |
|
|
SRID |
Spatial reference system identifier used for the coordinate geometry in this table. It is a foreign key reference to the SPATIAL_REF_SYS table. |
|
|
GEOM_TYPE
|
Geometry type that this column represents. Valid values include: |
|
|
|
|
|
|
UxMin |
Lower left X coordinate of the MBR for the universe that includes all values that this column might hold. |
|
|
UyMin |
Lower left Y coordinate of the MBR for the universe that includes all values that this column might hold. |
|
|
UxMax |
Upper right X coordinate of the MBR for the universe that includes all values that this column might hold. |
|
|
UyMax |
Upper right Y coordinate of the MBR for the universe that includes all values that this column might hold. |
|
To add geometry metadata for an ST_Geometry column to the GEOMETRY_COLUMNS table, you can use the SYSSPATIAL.AddGeometryColumn stored procedure.
To drop geometry metadata from the GEOMETRY_COLUMNS table, you can use the SYSSPATIAL.DropGeometryColumn stored procedure.
For details, see “AddGeometryColumn Stored Procedure” on page 216 and “DropGeometryColumn Stored Procedure” on page 220.