IsValidDetailed (geometry DataType)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

Returns a message that can help to identify problems with a spatial object that is not valid. When the object is not valid, only the first error is returned. When the object is valid, a value of 24400 is returned.




To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

Return Types

SQL Server return type: nvarchar(max)

CLR return type: string


The following table contains possible return values:

Return value Description
24400 Valid
24401 Not valid, reason unknown.
24402 Not valid because point {0} is an isolated point, which is not valid in this type of object.
24403 Not valid because some pair of polygon edges overlap.
24404 Not valid because polygon ring {0} intersects itself or some other ring.
24405 Not valid because some polygon ring intersects itself or some other ring.
24406 Not valid because curve {0} degenerates to a point.
24407 Not valid because polygon ring {0} collapses to a line at point {1}.
24408 Not valid because polygon ring {0} is not closed.
24409 Not valid because some portion of polygon ring {0} lies in the interior of a polygon.
24410 Not valid because ring {0} is the first ring in a polygon of which it is not the exterior ring.
24411 Not valid because ring {0} lies outside the exterior ring {1} of its polygon.
24412 Not valid because the interior of a polygon with rings {0} and {1} is not connected.
24413 Not valid because of two overlapping edges in curve {0}.
24414 Not valid because an edge of curve {0} overlaps an edge of curve {1}.
24415 Not valid some polygon has an invalid ring structure.
24416 Not valid because in curve {0} the edge that starts at point {1} is either a line or a degenerate arc with antipodal endpoints.


The following example of an invalid spatial object illustrates how the IsValidDetailed() methods behaves.

DECLARE @p GEOMETRY = 'Polygon((2 2, 4 4, 4 2, 2 4, 2 2))'  
SELECT @p.IsValidDetailed()  
--Returns: 24404: Not valid because polygon ring (1) intersects itself or some other ring.  

See Also

Extended Methods on Geometry Instances