Database Schema
Il est cinq heures • Jacques Dutronc • 1968
• T-Sql
Schema is a logical collection of database object associated with a database such as tables, views, stored procedures, functions, indexes, triggers …
An user of a databses is called a Schema owner. A schema belongs to a single database, and one dabase can have a single or multiple schemas.
` [database].[schema].[table]`
Advantages:
- a database, logical collection of database objects associated with a database such as tables, views, stored procedures, functions, indexes, triggers.
- apply security permissions for separating and protecting database objects based on user access rights.
- apply security permissions for separating and protecting database objects based on user access rights.
- apply security permissions for separating and protecting database objects based on user access rights.
SQL Server provides some pre-defined schemas which have the same names as the built-in database users and roles, for example: dbo
, guest
, sys
, and INFORMATION_SCHEMA
. The dbo schema
is the default schema.