Can you change the reference column name default?

Cory Isaacson il y a 7 ans mis à jour par anonymous il y a 7 ans 1

When I add a reference it always adds a column like: TableName_pkColumnName. I like it better when the FK reference column has the same name as the parent PK column name, so just: pkColumnName. I added the column in the FK reference manually, and it still adds the other. Then I have to delete the extra column, delete the reference and add a new reference, which is kind of a lot of work for every reference.

Any way around this?


ery fast and answered my question, thanks.

Note de satisfaction par Cory Isaacson il y a 7 ans

Hello. You can turn off autogeneration of FK in 'My account' tab. You have to find section 'Personal preferences', then set 'Autogeneration FK' to 'No' and save changes.