dbo在SQL中的含义 [英] what dbo meant in SQL

问题描述

是默认

推荐答案

dbo = D ata B ase O bject

有关更多信息，请访问: http://msdn.microsoft.com/library/ms190328%28v=sql .105％29.aspx [ ^ ]
http://msdn.microsoft.com/library/ms176130%28v=sql.100% 29.aspx [ ^ ]

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 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.

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

我建议您购买好书或使用

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

I recommand you to buy good book or use google[^] to find an answers.

对象是在SQL Server 2000或更早版本中创建的，该对象必须具有所有者.大多数情况下，所有者是"dbo"，也称为数据库所有者.数据库中的任何用户帐户都可能拥有一个对象.确定所有者的方法是查看查看表列表时可以使用SQL Server企业管理器或Management Studio查看的标准对象名称.例如，dbo拥有的名为orders的表的名称为dbo.orders.如果该表的所有权已转移给用户abc，则该表现在将命名为abc.orders.

有关更多信息，请参见: http://www.sqlteam. com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server [

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[^]

dbo数据库对象.这些是组成完整的RDBMS的要素.它们有助于创建参照完整性，唯一性，数据一致性和约束...
dbo的示例包括:表，视图.存储过程，索引...等

谢谢

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

这篇关于dbo在SQL中的含义的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！