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.
Post your comments / questions
Recent Article
- How to load data from json file in angular?
- cannot find module consider using '--resolvejsonmodule' to import module with json extension angular
- How to create multi select dropdown in Angular?
- Argument of type 'string | null' is not assignable to parameter of type 'string'.\n Type 'null' is not assignable to type 'string'
- No 'access-control-allow-origin' header is present on the requested resource Angular CORS policy Error
- Access denied sql server attach database
- Visual studio Code change default terminal to cmd
- How to attach database in sql server using cmd?
Related Article