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.

We have a SQL Server database setup here that users access as part of a class. The professor is requesting that the users be able to create and drop tables in their own "workspace" while they're ...