Dropping the indexes before recreating them will also drop all the referencial integrity rules that are set in the database. If you do not use that feature (and will never do), then your suggestion will work. Otherwise, a tool like SDT will greatly help.

>All the information about indexes for a table can be found using: ATagInfo()
>Then all you have to do is step through the array and recreate all the indexes.