sp_help_spatial_geometry_index (Transact-SQL)

Applies to: SQL Server

Returns the names and values for a specified set of properties about a geometry spatial index. The result is returned in a table format. You can choose to return a core set of properties or all properties of the index.

Transact-SQL syntax conventions

Syntax

sp_help_spatial_geometry_index
    [ @tabname = ] N'tabname'
    , [ @indexname = ] N'indexname'
    , [ @verboseoutput = ] verboseoutput
    , [ @query_sample = ] query_sample
[ ; ]

Arguments and properties

See Spatial index stored procedures - arguments and properties.

Permissions

User must be assigned a public role to access the procedure. Requires READ ACCESS permission on the server and the object.

Remarks

Properties containing NULL values aren't included in the return set.

Examples

The following example uses sp_help_spatial_geometry_index to investigate the spatial index SIndx_SpatialTable_geometry_col2 defined on table geometry_col for the given query sample in @qs. This example returns only the core properties of the specified index.

DECLARE @qs geometry = 'POLYGON((-90.0 -180.0, -90.0 180.0, 90.0 180.0, 90.0 -180.0, -90.0 -180.0))';

EXEC sp_help_spatial_geometry_index
    'geometry_col',
    'SIndx_SpatialTable_geometry_col2',
    0,
    @qs;