SQL Server Non Clustered Keys

To define a primary key as non-clustered for a SQL Server table, follow the steps below:

  1. Right-click on the table in a diagram to open the context menu.
  2. Select the Operations menu option. The Table Operations dialog displays.
  3. Highlight the Primary Key Operation and select Extended Properties. The Database Operation Properties dialog displays.
  4. Select the SQL Server Non Clustered Primary Key checkbox.
  5. Click on the Save & Close button.