Home > Posts > SQL Server Index List

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

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

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.