General information
Category:
Coding, syntax & commands
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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only