Sql Server Management Studio Intellisense Refresh - 5/7/2010

I started using Sql Server 2008 not so long ago and, being a huge fan of intellisense, asbsolutely love the fact that the Management Studio 2008 has it.

It is fairly common taks for me to make some changes to the schema of a table (like adding a new field) and then immediatly change the stored procedures that read from and write to that table. But I was quite frustrated to discover that the the beloved Intellisense did not recognize my new field. Sometimes I would go through the trouble of restarting the Management Studio, which does fix the problem but kind of blows the time saving beauty of Intellisense.

But then, Voilà, Inellisense can be refreshed using the menus in Management studio.

Edit -> Intellisene -> Refresh Local Cache