May 28, 2008 at 1:44 am
hi .. iam new in SQL server i dont Know why we need schema exactly?what is the purpose of schema???
May 28, 2008 at 2:06 am
Schema have many purposes,One thing is you can create tables having same name under different schemas.
May 28, 2008 at 2:26 am
This link might be useful - http://msdn.microsoft.com/en-us/library/ms190387.aspx
May 28, 2008 at 2:28 am
Schema are logical container to store database objects and are used for security purposes for example let assume I have 10 tables in my database that needs to be viewed by Management department only. So we can create the Management Schema and store all these objects in that schema. And grant the management department user or roles permission on that schema.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 28, 2008 at 11:16 am
be careful of schemas, they are always looking to scheme you out of something
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply