We did not specify any schema in the CREATE TABLE statement. We can verify the default schema for a user using the following system function: If we do not define any default schema for a user, SQL Server assumes dbo as the default schema. We define default SQL Schema for a database user in the create database user window: We get more control over database objects access and security It allows you to move database objects among the schemas We can share a schema among multiple users We can quickly transfer ownership of a SQL schema to another user We can have a single or multiple schema owners. Now, the database object owner is a schema, and we define schema owners. Starting from SQL Server 2005, we have different meanings of user and schema. We do not have any restrictions on the number of objects in a schema. It is a useful mechanism to segregate database objects for different applications, access rights, managing the security administration of databases. A user owns that owns the schema is known as schema owner. We define SQL Schema as a logical collection of database objects. This article gives an overview of SQL Schema and its usage in SQL Server.Ī SQL database contains multiple objects such as tables, views, stored procedures, functions, indexes, triggers.
