SpatialIndexType Property
Collapse the table of content
Expand the table of content

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)

[SfcPropertyAttribute(SfcPropertyFlags::None | SfcPropertyFlags::ReadOnlyAfterCreation | SfcPropertyFlags::Standalone | SfcPropertyFlags::SqlAzureDatabase)]
property SpatialIndexType SpatialIndexType {
	SpatialIndexType get();
	void set(SpatialIndexType value);

Property Value

Type: Microsoft.SqlServer.Management.Smo::SpatialIndexType

The Spatial Index Type for a column.

Valid values for the SpatialIndexType property are:



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 M:Microsoft.SqlServer.Managemetn.Smo.Index.Alter method. To change the property, the index must be rebuilt or re-created.

Return to top
© 2016 Microsoft