Maybe everybody does this, but when I am developing and maintaining a system, I have an indexing program that creates every index I use in the entire system. This serves as 1)allows the user to recreate the indexes even if they are missing entirely 2) serves as a refference of all the tables & their associated indexes when I need to work on the system at a later time.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.