What is SQL Server deferred name resolution and its use cases?

Deferred name resolution allows stored procedures to compile even if referenced tables do not exist yet.

SQL Server allows compilation of stored procedures even if referenced tables are missing at creation time. Object name resolution is deferred until execution. This is useful for deployment scenarios but can lead to runtime failures if schema mismatches occur. It also impacts dependency tracking and plan compilation accuracy.