SQL Server Error Msg 1762 – Cannot create the foreign key “%.*ls” with the SET DEFAULT referential action, because one or more referencing not-nullable columns lack a default constraint.

In this blog post, let’s learn about the error message “1762 – Cannot create the foreign key “%.*ls” with the SET DEFAULT referential action, because one or more referencing not-nullable columns lack a default constraint.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

1762 – Cannot create the foreign key “%.*ls” with the SET DEFAULT referential action, because one or more referencing not-nullable columns lack a default constraint.

Reason for the Error

To be update soon…

Solution

To be update soon…