Working with Indexes (Visual Database Tools)

An index is a mechanism for providing fast access to table rows or for enforcing certain constraints.

For details about working with indexes, see the following topics.

In This Section

How to: Create Indexes (Visual Database Tools)

How to: Create Unique Indexes (Visual Database Tools)

How to: Create Clustered Indexes (Visual Database Tools)

How to: Create Full-Text Indexes (Visual Database Tools)

How to: Change Index Properties (Visual Database Tools)

How to: Rename Indexes (Visual Database Tools)

How to: Delete Indexes (Visual Database Tools)

How to: Delete Full-Text Indexes from Databases (Visual Database Tools)

How to: Specify Fill Factors for Indexes (Visual Database Tools)

How to: Show Index Properties (Visual Database Tools)

How to: Create XML Indexes (Visual Database Tools)

How to: Delete XML Indexes (Visual Database Tools)