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.

Didn't find what you were looking for?