sys.spatial_indexes (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Represents the main index information of the spatial indexes.

Applies to: SQL Server (SQL Server 2008 through current version).
Column nameData typeDescription
<inherited columns>Inherits columns from sys.indexes.
spatial_index_typetinyintType of spatial index:

1 = Geometric spatial index

2 = Geographic spatial index
spatial_index_type_descnvarchar(60)Type description of spatial index:

GEOMETRY = geometric spatial index

GEOGRAPHY = geographic spatial index
tessellation_schemesysnameName of tessellation scheme:

GEOMETRY_GRID, GEOMETRY_AUTO_GRID,

GEOGRAPHY_GRID, GEOGRAPHY_AUTO_GRID

Note: For information about tessellation schemes, see Spatial Indexes Overview.
<inherited columns>Inherits columns from sys.indexes.

The inherited columns has_filter and filter_definition appear after the columns that are specific to spatial indexes.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.

sys.objects (Transact-SQL)
sys.spatial_index_tessellations (Transact-SQL)
sys.indexes (Transact-SQL)
sys.index_columns (Transact-SQL)
Spatial Indexes Overview

Community Additions

ADD
Show: