drop index specification and generator