PE023

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.


This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved


Didn't find what you were looking for?