SQL Server Performance Forum – Threads Archive

Default Schema

I have started working on SQL 2005 recently.
I still have to go a long way ahead…
Pls help in letting me know,what exactly is the Default Schema?I am not able to change this as well. What does Schema owned by this User signify?

---

schema is container. objects are in a schema. users have access to schema
if user owns a schema, you can’t drop the user before changing the ownership. when you are accessing a object it has to be select * from DBname.Schma.Object if you are accessing your defaut schema you don’t have to write schema —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

get more info http://www.databasejournal.com/features/mssql/article.php/3481751 http://msdn2.microsoft.com/en-gb/library/ms190387.aspx —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

If DEFAULT_SCHEMA is left undefined, the user will have dbo as its default schema. DEFAULT_SCHEMA can be set to a schema that does not currently exist in the database. Therefore, you can assign a DEFAULT_SCHEMA to a user before that schema is created. DEFAULT_SCHEMA cannot be specified for a user that is mapped to a Windows group, a certificate, or an asymmetric key. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

]]>