SQL Foreign Key Constraints -
i upgrading our erp system significant upgrade, data ready real time conversion using script ( cannot see ) run problem following error:
[microsoft][odbc sql server driver][sql server]the constraint 'ardiscdrcrdetkey' being referenced table 'ardiscdrcrhdr', foreign key constraint 'syspro_ardiscdrcrhdr_ardiscdrcrdet'. converting ardiscdrcrdet.sequence not nullable recreating key table ardiscdrcrdet added new format key ardiscdrcrdetkey error - [microsoft][odbc sql server driver][sql server]table 'ardiscdrcrdet' has primary key defined on it.
i cannot delete tables or drop keys 1 one. erp company support staff struggling assist me, have knowledge regarding assist me?
Comments
Post a Comment