Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the Open Geospatial Consortium (OGC) type name represented by a geography instance.
Syntax
.STGeometryType ( )
Return Types
SQL Server return type: nvarchar(4000)
CLR return type: SqlString
Remarks
The OGC type names that can be returned by STGeometryType() are Point, LineString, CircularString, CompoundCurve, Polygon, CurvePolygon, GeometryCollection, MultiPoint, MultiLineString, and MultiPolygon.
Examples
The following example creates a Polygon instance and uses STGeometryType() to confirm that it is a polygon.
DECLARE @g geometry;
SET @g = geometry::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326);
SELECT @g.STGeometryType();