SQL Server 2005 Schema, Schema Properties, Schema T-SQL

What is Schema in SQL Server 2005? Explain its properties with example?

A schema is nothing more than a named, logical container in which you can create database objects. A new schema is created using the CREATE SCHEMA DDL statement.


  • Ownership of schemas and schema-scoped securables is transferable.
  • Objects can be moved between schemas
  • A single schema can contain objects owned by multiple database users.
  • Multiple database users can share a single default schema.
  • Permissions on schemas and schema-contained securables can be managed with greater precision than in earlier releases.
  • A schema can be owned by any database principal. This includes roles and application roles.
  • A database user can be dropped without dropping objects in a corresponding schema.



Create database SQL2k5

Use SQL2k5


— Created Schema Employee —

Create Schema Employee


— Created table in Employee schema —

Create Table Employee.EmpInfo


EmpNo int Primary Key identity(1,1),

EmpName varchar(20)



— data insertion


Insert Into Employee.Empinfo Values(‘Jshah-3’)


— Data Selection —

Select * From Employee.Empinfo


— Created another schema HR —

Create Schema HR


— Transfer Objects between Schemas —


TRANSFER Employee.Empinfo


— Assigning Permission to Schema —




6 thoughts on “SQL Server 2005 Schema, Schema Properties, Schema T-SQL

  1. anil

    Can I have a decent web chat in ASp.Net C# which I can implemented on my site. I get lot of open source web chat and not a single one in Asp.Net.

  2. Sergio

    А если посмотреть на это с другой точки зрения то не все так гладко получается

  3. farengayts

    сёдня наконец-то пришёл конвертик от space-shop.org! всё без палева и чётко! буду и дальше у вас заказывать!


Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s