Export (0) Print
Expand All

sys.spatial_indexes (Transact-SQL)

Represents the main index information of the spatial indexes.

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type

Description

<inherited columns>

Inherits columns from sys.indexes.

spatial_index_type

tinyint

Type of spatial index:

1 = Geometric spatial index

2 = Geographic spatial index

spatial_index_type_desc

nvarchar(60)

Type description of spatial index:

GEOMETRY = geometric spatial index

GEOGRAPHY = geographic spatial index

tessellation_scheme

sysname

Name of tessellation scheme:

GEOMETRY_GRID, GEOMETRY_AUTO_GRID,

GEOGRAPHY_GRID, GEOGRAPHY_AUTO_GRID

Note 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft