Published 24 November 2017
DDL without specifying a schema name for table
The same object name can exist in multiple schemas; if a schema name is not specified, SQL Server will assume the current user's default schema is the intended destination. Additionally, The compiler can interpret a two-part object name quicker than just one name. This applies particularly to tables, views, procedures and functions.