If you change the table, then when writing a query in SQL Server Management Studio, code completion no longer works. Is there any way to clear this cache?
(SQL Server 2008)
You can try
Edit -> Intellisense -> Update Local Cache (CTRL + Shift + R)
From Upgrading / Upgrading SQL Server 2008 Intellisense When Changing Schema