Tag: index details

  • Find Indexed column details in a database

    I was looking for a script to find out the indexed column details as part of our migration. I tried to use sp_helpindex however it requires a object name which means you can find details for only one table at a time. My requirement is to get details about all indexed columns across the database…

  • Index Details for Tables

    This script will list out the details of the indexes in a table.This is compatible to SQL 2000 and 2005.