Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - What Is a Schema in SQL Server 2005

By: FYIcenter.com

(Continued from previous topic...)

What Is a Schema in SQL Server 2005?

A schema is a container of database objects with the following interesting related rules:

• A schema may contain different object types, like tables, indexes, views, procedures, functions, etc.
• A database user can be assigned with a default schema.
• Object names must be prefixed with schema names when referencing schemas outside your default schema.
• Every schema has a single owner (a database user). A database user may own multiple schemas.
• If you login name is mapped to the owner of a schema, you have full permissions on this schema.
• To drop a schema, you need to empty the schema first.

(Continued on next topic...)

1. What Is a Schema in SQL Server 2005?
2. How To Create a New Schema in a Database?
3. How To List All Schemas in a Database?
4. How To Create a New Table in a Given Schema?
5. How To Transfer an Existing Table from One Schema to Another Schema?
6. How To List All Objects in a Given Schema?
7. What Is the Default Schema of Your Login Session?
8. Who Is the Owner of a Schema?
9. How To Change the Ownership of a Schema?
10. What Happens If You Are Trying to Access a Schema Not Owned by You?
11. How To Drop an Existing Schema?