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)
);
Syntax Elements
- 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:
- GEOMETRY
- POINT
- LINESTRING
- POLYGON
- GEOMETRYCOLLECTION
- MULTIPOINT
- MULTILINESTRING
- MULTIPOLYGON
- GEOSEQUENCE
- 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.