What Is a Schema in SQL Server 2005 in SQL Server


What Is a Schema in SQL Server 2005 in SQL Server?

✍: FYIcenter.com


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.


Creating and Managing Schemas in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-22, 627👍, 0💬