indexing - Generate CREATE INDEX statements in SQL Server

Question

Does anyone have a script to list of CREATE INDEX statements for all existing indexes in a SQL Server database?

This thread List of all index & index columns in SQL Server DB has great tips on how to find them. But a script to generate the CREATE INDEX statements would be great. Sometimes we come into a situation without adequate data, or indexes have been added in an ad-hoc manner over time without documentation, so the create statements are missing. Like in a situation I find myself in right now.

Thanks.

Answer 1

Use Generate Scripts from SQL Management Studio and choose the "Script Indexes" options (under Advanced Scripting options)