This script queries the sys tables and gets the same information about indexes for all the tables in a database as sp_helpindex and stores them in two tables created by the script. Quite a useful script if you have a large number of tables in a database with many developers adding, dropping, or modifying indexes. Run from the QA after editing the script for selecting the database. Tested on SQL 7.0.

Author: Vijay Koranki

Download Script:

We hope that the information on these script pages is
valuable to you. Your use of the information contained in these pages,
however, is at your sole risk. All information on these pages is provided
“as -is”, without any warranty, whether express or implied, of its accuracy,
completeness, or fitness for a particular purpose…

Disclaimer Continued

Back to Database Journal Home

Latest Articles