15.10 - DropGeometryColumn Stored Procedure - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Drop geometry metadata from the SYSSPATIAL.GEOMETRY_COLUMNS table for an ST_Geometry column

 

Parameter …

Specifies …

catalog_name

the name of the catalog.

The value can be an empty string ('') for Teradata.

schema_name

the name of the database in which the table specified by table_name is defined.

table_name

the name of the table that has a column defined as an ST_Geometry type.

geom_column_name

the name of the column in the table specified by table_name that is defined as an ST_Geometry type.

VARCHAR(1024)

You can optionally use this stored procedure to drop metadata from the SYSSPATIAL.GEOMETRY_COLUMNS table when you drop or alter a table that has a column defined as an ST_Geometry type.

Stored procedures are invoked using the CALL statement. For more information, see SQL Data Manipulation Language

The following examples correspond to the examples used for “AddGeometryColumn Stored Procedure” on page 216.

CALL SYSSPATIAL.DropGeometryColumn('','OpenGISU','lakes','shore',s);
 
CALL SYSSPATIAL.DropGeometryColumn('','OpenGISU','road_segments',
     'centerline', s );