DataStreams
Framework for reading, writing, and bulk inserting files from .Net Download Demo

SQL Data Dictionary
Quickly and easily document your SQL Server database Download Demo

Home > Posts > SQL Server Index List

This script generates a full list of all index definitions for all tables in a SQL Server database for easy review.

Download index_list.sql (Right Click->Save Target As...).

It includes schemas, primary keys, clustered indexes, padding, included columns, and important column definitions like nulls, identities, and data types.

Please send any questions or comments to Bruce Dunwiddie.