0
Not a bug

Don'tt update the column type PK-FK relationships

Michael Medina 4 years ago • updated by Michał Kołodziejski 4 years ago 3
When I change the column type to another value in a table with PK in another table that contains the FK does not update.

It will correct this?

Sorry for my english, thanks.

Answer

Answer
Not a bug
Not updating the type of FK column is a desired behaviour. This is because you can have, for instance, "SERIAL" datatype for your PK and "INT" type for FK and this is perfectly valid structure (I'm talking about PostgreSQL now, but such cases exist in other RDBMSs as well).
If you change the PK type and the types of PK and FK don't match, you should get an error in the "Problems" section.
Answer
Not a bug
Not updating the type of FK column is a desired behaviour. This is because you can have, for instance, "SERIAL" datatype for your PK and "INT" type for FK and this is perfectly valid structure (I'm talking about PostgreSQL now, but such cases exist in other RDBMSs as well).
If you change the PK type and the types of PK and FK don't match, you should get an error in the "Problems" section.
Hello

If you're right, but in my opinion when you change the data type in my PK, FK should not automatically change it manually.

Another observation I could see is that by eliminating the relationship between two tables "a" and "b", the referenced FK not removed, you also would have to do it manually?

This drawback I see for SQL Server, if not for others will be the same.

Sorry for my English.

Thank you.
+1
If it's about automatic FK column removal after reference deletion - I agree. We have this on our TODO list and it will be done in the nearest future, maybe even in the next week!