SQL

The following data type properties of column do not match those of Data type, length, precision.

The following data type properties of column do not match those of Data type, length, precision., someone asked me to explain?
SQL

The following data type properties of column do not match those of Data type, length, precision.

Initially I want to apply the foreign key for Student table .But the error occurred. Because of variation in data type. I got the following error “The following data type properties of the column do not match those of Data type, length, precision”

Solution:

I used int data type for department table. But in foreign I used smallint data type. So I changed both of them into int data type. Finally I successfully saved the table.

 

data type properties of column do not match those of Data type

Post your comments / questions