Error Code 10005
While adding foreign key constraint i got 1005 error code, weird thing about this error is that it tells "can't create table sql 150 error"
Possible reason:
1. Data type of primary & foreign key mismatch.
2. Length of data type different ex: primary key = int(10) & foreign key = int(11)
3. primary column may already drop.
4. constraint name already exist in database.
While adding foreign key constraint i got 1005 error code, weird thing about this error is that it tells "can't create table sql 150 error"
Possible reason:
1. Data type of primary & foreign key mismatch.
2. Length of data type different ex: primary key = int(10) & foreign key = int(11)
3. primary column may already drop.
4. constraint name already exist in database.
No comments:
Post a Comment