SQL Server indexes

To add a new index to a database table, edit your table, navigate to tab Indexes and click + Add Index.

Then add columns to the index. Click +Add Column to Index to display a dropdown with a list of available column names. Pick a column and then specify other index properties.

Index definition

Index types

The following index types are supported:

  • Relational
  • Spatial
  • XML
  • Columnstore

Display mode & Indexes

You can activate index display instead of column details. Click the Display button on the main toolbar and select Indexes.

Indexes displayed in ERD


Quick links

Free Trial Buy Now!