What is Database Schema ?

Posted by Karthikreddy under Sql Server on 3/8/2013 | Points: 10 | Views : 993 | Status : [Member] | Replies : 3
What is Database Schema ? what are benefits ?

k@rth!k
karthikreddy08a50@gmail.com



Responses

Posted by: Satyapriyanayak on: 3/8/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_database_schemas.cfm

http://www.databaseanswers.org/tutorial4_db_schema/index.htm

If this post helps you mark it as answer
Thanks

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 3/8/2013 [Member] [MVP] Gold | Points: 25

Up
0
Down

A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.
You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.

Schemas can be created and altered in a database, and users can be granted access to a schema. A schema can be owned by any user, and schema ownership is transferable.

Refer this url:
http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_database_schemas.cfm

Please Mark As Answer if this helps you

.

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sahoomanoj27 on: 3/14/2013 [Member] Starter | Points: 25

Up
0
Down
SCHEMA ARE THE OWNER OF THE DATABASE OBJECTS.
SCHEMA OWNER CAN BE CHANGED.

Karthikreddy, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response