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.

The data for these tables is coming from another source that is not supported by Entity Framework, but does have a minimalist SQL API, so what we have done is create a migration tool that creates ...