Invalid object name in Stored Procedure Alter Command

If you are working with stored procedure using SQL Server Management Studio Tools (SSMS), you will encounter a problem (well, not really a problem) “Invalid object name” on the name of your stored procedure.

Please see screenshot below:

This error is not made by SQL Server but rather by SSMS. The solution to this problem is to clear the intelliSense cache. Click on Edit menu => IntelliSense => Refresh Local Cache or press Ctrl + Shift + R at the same time.