Each row of the ST_GEOMETRY_COLUMNS system view describes a spatial column defined in the database.
| Column name | Data type | Description |
|---|---|---|
| table_catalog | VARCHAR(128) | For internal use. |
| table_schema | CHAR(128) | The name of the schema to which the table containing the spatial column belongs. This is equivalent to the table owner. |
| table_name | CHAR(128) | The name of the table containing the spatial column. |
| column_name | CHAR(128) | The name of the spatial column. |
| srs_name | CHAR(128) | The name of the SRS that is associated with the spatial column. If an SRS is not associated with the column, then srs_name is NULL. |
| srs_id | INTEGER | The SRID for the SRS associated with the spatial column. |
| table_id | UNSIGNED INT | The numeric identifier for the table containing the column. |
| column_id | UNSIGNED INT | The numeric identifier for the column. |
| geometry_type_name | VARCHAR(32767) | The spatial data type of the geometries contained in the column (for example, ST_Point, ST_Geometry, and so on.) |