Mark Tabor

Mark Tabor

  • 589
  • 2k
  • 456.9k

How to make primary and foreign key of different data types

Jun 22 2016 12:57 AM
I have two tables and these both are associated based on primary foreign key relationship , in my one table i have the data type of that column tinyint and in another table i have a data type of int , now when i am going to create a relationship it gives an error , I could not change the data type because for that i have to change in hundreds of places how to make the relationship between two columns of different tables having different data types.

Answers (3)