Script all indexes as CREATE INDEX statements

By Lowell, 2006/03/17

Total article views: 1786 | Views in the last 30 days: 204

Rate this |

Join the discussion |

Briefcase

this script will generate CREATE index statements for all indexes in the database;
there are already scripts out there that script constraints for primary keys and unique constraints, which automatically create an index behind the scenes. but what about the other indexes?
uncomment two statements in order to filter out primary keys and Unique indexes so you can get all the other types,

By Lowell, 2006/03/17

Total article views: 1786 | Views in the last 30 days: 204

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Summary of how to manage FULL TEXT indexing in TSQ

By iecdba | Category: Index Management

| 322 reads

Function to List Primary Key Columns for a Table

By kgayda | Category: Miscellaneous

| 487 reads

Find Duplicate Indexes

By Jeff Weisbecker | Category: Miscellaneous

| 612 reads

Finding missing indexes in sql server 2005

By himanshu | Category: Index Management

| 979 reads

Like this? Try these...

Tables NOT having FK

By ravi lobo | Category: Miscellaneous

| 152 reads

Get Primary Key columns of given MSSQL table

By vanaspati | Category: SQLInsider Scripts

| 336 reads

Stored Proc to List Columns for a Primary Key

By Charles Hawkins | Category: Miscellaneous

| 371 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com