Deleting an Index with SQL DDL

You can delete an index from a table with the DROP INDEX statement:

DROP INDEX Ix_Violation_Type ON Parking_Tickets;

Note that it may or may not be possible to delete an index at any given time, depending on the inter-table relationships you’ve defined. To set up referential integrity between two tables, the fields used to link tables must be indexed. For more information about setting up table relationships and their effect on indexes, see the “Referential Integrity and Relationships” section later in this chapter.