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