sys.spatial_indexes (Transact-SQL)
Represents the main index information of the spatial indexes.
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 GEOGRAPHY_GRID .gif "Note") Note
For information about tessellation schemes, see Spatial Indexing Overview.
|
Permissions
In SQL Server 2005 and later versions, 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. For more information, see Metadata Visibility Configuration.