How to: Delete Spatial Indexes
You can delete a spatial index when you no longer need it. For more information about spatial indexes, see "Spatial Indexing Overview" on the Microsoft Web site.
Note
A new version of Table Designer appears for databases in the SQL Server 2012 format. This topic describes the old version of Table Designer, which you use with databases in earlier formats of SQL Server.
In the new version, you can change a table definition through a graphical interface or directly in a script pane. If you use the graphical interface, the table’s definition is automatically updated in the script pane. To apply the SQL code in the script pane, choose the Update button. For more information about the new version, see How to: Create Database Objects Using Table Designer.
To delete a spatial index
In Server Explorer, click the database table that has the spatial index that you want to delete.
On the Database menu, click Open Table Definition.
The table opens in Table Designer.
On the Table Designer menu, click Spatial Index.
The Spatial Index dialog box opens.
In the Selected Spatial Index column, click the index that you want to delete, and then click Delete.