dbinxinfo.txt

September 5, 2001



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








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers