Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
'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
[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
Microsoft.SqlServer.Management.Smo Namespace