Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

Working with Indexes (Visual Database Tools)

An index is a mechanism for providing fast access to table rows or for enforcing certain constraints. For information about how to work 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: Create a Spatial Index (Visual Database Tools)

How to: Create XML Indexes (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: Delete a Spatial Index (Visual Database Tools)

How to: Delete XML Indexes (Visual Database Tools)

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

How to: Show Index Properties (Visual Database Tools)


Additional resources


  • Last updated on 2012-10-04

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026