Aracılığıyla paylaş


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)

Syntax

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

value = instance.SpatialIndexType

instance.SpatialIndexType = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public SpatialIndexType SpatialIndexType { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property SpatialIndexType SpatialIndexType {
    SpatialIndexType get ();
    void set (SpatialIndexType value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member SpatialIndexType : SpatialIndexType with get, set
function get SpatialIndexType () : SpatialIndexType
function set SpatialIndexType (value : SpatialIndexType)

Property Value

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

Remarks

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.

See Also

Reference

Index Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DEL - Spatial Indexing Overview