--- title: "sys.spatial_indexes (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "06/10/2016" ms.prod: "sql-non-specified" ms.reviewer: "" ms.suite: "" ms.technology: - "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords: - "sys.spatial_indexes_TSQL" - "spatial_indexes" - "spatial_indexes_TSQL" - "sys.spatial_indexes" dev_langs: - "TSQL" helpviewer_keywords: - "sys.spatial_indexes catalog view" ms.assetid: 40e967d5-2e8d-45af-bf5e-5251493cf7cb caps.latest.revision: 27 author: "BYHAM" ms.author: "rickbyh" manager: "jhubbard" --- # sys.spatial_indexes (Transact-SQL) [!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)] Represents the main index information of the spatial indexes. || |-| |**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] ([!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] through [current version](http://go.microsoft.com/fwlink/p/?LinkId=299658)).| |Column name|Data type|Description| |-----------------|---------------|-----------------| |\||Inherits columns from [sys.indexes](../../relational-databases/system-catalog-views/sys-indexes-transact-sql.md).| |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: For information about tessellation schemes, see [Spatial Indexes Overview](../../relational-databases/spatial/spatial-indexes-overview.md).| |\||Inherits columns from [sys.indexes](../../relational-databases/system-catalog-views/sys-indexes-transact-sql.md).

The inherited columns has_filter and filter_definition appear after the columns that are specific to spatial indexes.| ## Permissions [!INCLUDE[ssCatViewPerm](../../includes/sscatviewperm-md.md)] ## See Also [sys.objects (Transact-SQL)](../../relational-databases/system-catalog-views/sys-objects-transact-sql.md) [sys.spatial_index_tessellations (Transact-SQL)](../../relational-databases/system-catalog-views/sys-spatial-index-tessellations-transact-sql.md) [sys.indexes (Transact-SQL)](../../relational-databases/system-catalog-views/sys-indexes-transact-sql.md) [sys.index_columns (Transact-SQL)](../../relational-databases/system-catalog-views/sys-index-columns-transact-sql.md) [Spatial Indexes Overview](../../relational-databases/spatial/spatial-indexes-overview.md)