ST_ExteriorRing Method | Geospatial Data Types | Teradata Vantage - 17.10 - ST_ExteriorRing - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Geospatial Data Types

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Get and set the exterior ring of an ST_Geometry type that represents an ST_Polygon value.

Valid Data Types


This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations. Consequently, any z coordinates returned by this method should be ignored. Teradata recommends using the Make_2D method to strip out the z coordinates of the return value.

Result Type

Returns an ST_Geometry value.

IF you … THEN ST_ExteriorRing returns …
do not pass in the acurve argument an ST_LineString of the exterior ring of the ST_Polygon.
pass in the acurve argument the new ST_Polygon with the exterior ring set to the value of the acurve argument.