I see in the PHysical Model settings, there are some abilities to auto-generate names. I would love to see something like TOAD for SQL Server, where the names are sensically and logicaly auto-generated. For instance, when I create a PK, it should not create Keyn (Key1, Key2, etc.). It should create PK_SchemaName_TableName_1. That’s the TOAD method. Better yet, have it create PK_SchemaName_TableName_PKColName.
Schema Name: dbo
Table Name: Sales
PK Col Name: SaleID
To access the column in SQL, I could write dbo.Sales.SaleID.
So, the PK should be named: PK_dbo_Sales_SaleID
This makes much logical sense!
Foreign Keys should be named similarly (following the TOAD model):
Or better yet:
FK_SchemaName_TableName_FKColName (assuming the FKColName is known).
So, if the table Sales had a column called SellerID, the FK relationship might be called: