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.