SQL Server Foreign Key Locking – Vlad Mihalcea Learn how SQL Server Foreign Key constraints are locking the parent record when executing a child record UPDATE.