How to make primary and foreign key of different data types
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.