dcsimg
 

dbinxinfo.txt

Thursday Sep 6th 2001 by DatabaseJournal.com Staff



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:
dbinxinfo.txt


Disclaimer: 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

Home
Mobile Site | Full Site