Studio does not remove unique index on join column for mssql

I recently switched from postgres to mssql.

I first encountered this issue: Unique index studio
where studio does not generate a nonclustered index for nullable unique columns.

I removed all unique constraints through the designer on such cases. For normal columns, studio will generate an update script to drop the unique index. However, it does not do that for joincolumns.

So I am forced to write my own update scripts

  • to add nonclustered indexes
  • to remove unique indexes for join columns

Hi,

Can you present an example? The source code of an entity and structure of the table and index in the database?