When and how are object dependencies updated? If I alter an existing stored procedure, the dependencies stay in tact. However, if I drop and recreate it, the dependencies are lost. I expect to lose the dependencies on the DROP, but I expect the dependencies to updated on CREATE. What am I missing?
--------------------
John