Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
When I create a database and add a user I get an interface with options. On that interface I can choose:
This question on dba.stackexchange HERE says schemas and roles are not related. This has confused me in the past since they have the same names. Why is this?
Also. In the Schemas folder, I see dbo, INFORMATION_SCHEMA, and sys. But in the user dialogue, under 'Owned Schemas' I don't see these options. Why is this?
This has confused me in the past since they have the same names. Why is this?
I think this is simply becuase of convention, it is easier to identify the owner of the schema.
Defualt schemas dbo, INFORMATION_SCHEMA, sys schemas are belongs to dbo, INFORMATION_SCHEMA, sys users respectively and these are inherited from model database.
INFORMATION_SCHEMA and sys are used to store system objects so that we can't select to store user-defined objects. dbo is the default schema so we don't need to select it.
