Generating Scripts only for Clustered and Non-Clustered indexes in SQL Server 2005

  • Article

In following cases you will need to generate a scripts for all the clustered and non-clustered indexes on the SQL Server 2005 database:

1. During heavy bulk inserts into a table, you might want to drop all the indexes on the table to make the bulk load process go faster.  Once the bulk load is done you can re-create those indexes back using the scripts.

2. If all the clustered and non-clustered indexes are built on a one single filegroup (PRIMARY, for example) and if you would like to move them to an appropriate filegroup (_DATA and _IDX, for example), you would need both create and drop scripts for clustered and non-clustered indexes.

There is a way to achieve that.   You can download a utility called DBScript from below website:

https://www.codeplex.com/SQLSrvScrpt/Wiki/View.aspx?title=DBScript%20Utility&referringTitle=Home

 

This utility will help you script clustered, non-clustered indexes, foreign keys, and triggers - both CREATE and DROP.