>>https://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/how-to-refresh-the-local-intellisense-ca/ > >Thanks, I have seen a related situation where the first command creates a field but SSMS won't run it because it already detects that the second command makes relation to a field which does not already exist. When that happens, I have to split the command into two windows. I then execute the first one so the field is created. Then, I can execute the second one successfully.
Yes, this is called deferred name resolution. Read this blog recently on this exact topic