c# .net Adsense ADO.NET Linq Viruses/security asp.net MVC JQuery Angular-js Node-js SEO Java C++ SQL API Networking vb.net .Net Css JavaScript Generics c#.Net entity framework HTML Website host Website Construction Guide HTTP tutorial W3C tutorial Web Services JSON Psychology Ionic framework Angular ReactJS Python Computer Android
SQL

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

| | 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.