Tag: index details
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…
This script will list out the details of the indexes in a table.This is compatible to SQL 2000 and 2005.