In the sql server 2005, why do I need to perform querying as followed
"SELECT * FROM Productiion.Product"
Why do i need to stick the prefix Production to the table named
"product" in Adventurework sample database?
Any idea would be appreciate.
Optimus wrote:
> In the sql server 2005, why do I need to perform querying as followed
> "SELECT * FROM Productiion.Product"
> Why do i need to stick the prefix Production to the table named
> "product" in Adventurework sample database?
> Any idea would be appreciate.
SQL Server 2005 uses the concept of schemas. That is, objects are owned
by schemas, and not users as they have been in the past. The separation
is beneficial. See "User-Schema Separation" in the SQL 2005 BOL for more
information.
David Gugick
Quest Software
www.imceda.com
www.quest.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment