OK, that's all well and good, but I left another detail out. <BR><BR>The amount of rows I want to delete from the first table is 516 and each one of those is referenced several times in table2.

If you drop a table with indexed columns, all the indexes are automatically dropped. If you drop a composite index, the index is dropped for all the columns that are named in that index.