O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Qualify Object Names with a Schema Name

In SQL Server 2005, the behavior of schemas was changed from earlier versions of SQL Server. SQL Server 2005 introduced definable schemas, which means schemas are no longer limited to database usernames only. Each schema is now a distinct namespace that exists independently of the database user who created it. Essentially, a schema is now simply a container for objects. A schema can be owned by any user, and the ownership of a schema is transferable to another user. This new feature provides greater flexibility in creating schemas and assigning objects to schemas that are not simply related to a specific database user. At the same time, it can create confusion if objects with the same name exist in multiple ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required