Export (0) Print
Expand All
Expand Minimize

Index.SpatialIndexType Property

Gets or sets the Spatial Index Type for a column.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public Property SpatialIndexType As SpatialIndexType 
	Get 
	Set
'Usage
Dim instance As Index 
Dim value As SpatialIndexType 

value = instance.SpatialIndexType

instance.SpatialIndexType = value

Valid values for the SpatialIndexType property are:

Value

Description

Index is not spatial

None = 0

Geometric Spatial Index Type

GeometryGrid = 1

Geography Grid Spatial Index Type

GeographyGrid = 2

This property cannot be modified by using the Alter method. To change the property, the index must be rebuilt or re-created.

Community Additions

ADD
Show:
© 2014 Microsoft