SQL Server indexes

To add a new SQL Server index to a database table in Luna Modeler, 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.

SQL Server indexes defined in Luna Modeler

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 ER Diagram for SQL Server.


Quick links

Download Buy Now!

Blog Categories
Blog by Platforms