# 3449 Trying to Alter a Table That is Opened Via a Foreign Key from Another Table Can Cause Locking Errors

---

I have a test database with 2 tables, table1 and table2. Table2 has a foreign key reference back to table 1. If you open table1 for editing and then attempt to alter table2, you get a 300 error indicating that you can’t get exclusive to table2. That’s fine and expected since table2 would be opened due to the FK reference. But once that error occurs, even if I close table1 and try the alter again with no tables open, table2 still can’t be opened in exclusive mode until the session is closed and opened again. So it looks like something isn’t being cleaned up properly after the failed alter attempt.