How to: Delete a Spatial Index (Visual Database Tools)
Delete a spatial index when it is no longer needed.
To delete a spatial index
In Object Explorer, right-click the table with the spatial index you want to delete and click Design.
The table opens in Table Designer.
On the Table Designer menu, click Spatial Index.
The Spatial Index dialog box opens.
Click the index you want to delete in the Selected Spatial Index column.
Click Delete.