Click here to Skip to main content
15,904,156 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
in sql dbo(Database Object)is default
what does it means can any one explain?
Posted

dbo = DataBaseObject

More at: http://msdn.microsoft.com/library/ms190328%28v=sql.105%29.aspx[^]
http://msdn.microsoft.com/library/ms176130%28v=sql.100%29.aspx[^]

Database objects:

Database objects are the underlying backbone of the relational database. This chapter discusses what they are, how they act, how they are stored, and how they relate to one another.

(...) These objects are logical units within the database that are used to store information and are referred to as the back-end database. The majority of the instruction during this hour revolves around the table, but keep in mind that there are other database objects, many of which are discussed in later hours of study.

What Are Database Objects?
A database object is any defined object in a database that is used to store or reference data. Some examples of database objects include tables, views, clusters, sequences, indexes, and synonyms. The table is this hour's focus because it is the primary and simplest form of data storage in a relational database.

Source: http://www.informit.com/articles/article.aspx?p=1216889[^]

I recommand you to buy good book or use google[^] to find an answers.
 
Share this answer
 
v5
Comments
kimberly wind 9-May-12 5:53am    
u provide link in polish . i don know tat language
Maciej Los 9-May-12 5:54am    
Ok, i'll correct it.
Done!
kimberly wind 9-May-12 5:57am    
i have seen tat link but am not able to understand anything can you please tel me simple answer if possible
member60 9-May-12 6:17am    
MY 5!
Maciej Los 9-May-12 6:19am    
Thank you ;)
When an object is created in SQL Server 2000 or earlier, the object must have an owner. Most of the time, the owner is “dbo”, also known as the database owner. It is possible that an object can be owned by any user account in the database. The way to determine the owner is by looking at the fully qualified object name which you can see using SQL Server Enterprise Manager or Management Studio when you are viewing a list of the tables. For example, the name of a table called orders owned by dbo is dbo.orders. If the table’s ownership is transferred to user abc, the table will now be named abc.orders.

for more refer:http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server[^]
 
Share this answer
 
Comments
Maciej Los 9-May-12 6:21am    
Good answer, my 5!
member60 9-May-12 7:04am    
thank you !
kevin_ze 9-May-12 8:41am    
Good Answer....
clearly explained....
dbo-Database Objects. These are the elements that make up a full RDBMS. They help create referencial intergrity, uniqueness, data consistency, and constraints...
Examples of dbo are: Tables, views. stored procedures, indexes....etc

thanks
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900