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?

Related Articles:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: