架构是什么意思？ [英] What does schema mean?
问题描述
我知道在SQL Server中使用了数据库和目录这两个术语
可以互换。但是表也被分配了一个模式。如在
INFORMATION_SCHEMA.Tables视图中所见。我没有得到这个架构限定符
的全部内容。就像表格有dbo架构一样。
有人可以解释架构之间的关系以及它是什么吗？
谢谢。
I know in SQL Server the terms Database and Catalog are used
interchangably. But a table is also assigned a schema. As seen in the
INFORMATION_SCHEMA.Tables View. I don''t get what this schema qualifier
is all about. Like if a table has a schema of dbo.
Can someone explain the relationship the schema has and what it is?
Thanks.
推荐答案
（wa ******** @ yahoo.com）写道：
(wa********@yahoo.com) writes:
I在SQL Server中知道术语数据库和目录是可互换使用的。但是表也被分配了一个模式。如
INFORMATION_SCHEMA.Tables视图中所示。我不知道这个架构限定符是什么。就像一个表有dbo模式一样。
有人可以解释模式之间的关系和它是什么吗？
I know in SQL Server the terms Database and Catalog are used
interchangably. But a table is also assigned a schema. As seen in the
INFORMATION_SCHEMA.Tables View. I don''t get what this schema qualifier
is all about. Like if a table has a schema of dbo.
Can someone explain the relationship the schema has and what it is?
请参阅模式为一种对数据库中的对象进行分类的方法。如果多个应用程序共享一个数据库，这可以是一件好事，虽然所有应用程序都可以访问一些常见的数据集，但某些应用程序也有
他们自己的私人表。在这种情况下，最好为每个应用程序都有一个单独的模式，在这些模式下，他们可以拥有自己的私有表，视图，存储过程等来逃避磁盘碰撞。
现在，在SQL 2000中，存在一个严重的限制，即架构与用户绑定了
。事实上，它使架构几乎无用。但是这个在用户已经与模式分离的SQL 2005中发生了变化。
最后，INFROAMTION_SCHEMA中的模式略有不同
用法。有时使用架构引用一些表，可能是数据库中所有表的b $ b。 SQL 2000甚至有一个CREATE SCHEMA命令
用于一次创建几个表。
-
Erland Sommarskog，SQL服务器MVP， es****@sommarskog.se
联机丛书SQL版服务器SP3在
http：// www .microsoft.com / sql / techinf ... 2000 / books.asp
See schema as a way of categorising the objects in a database. This can
be a good thing if several apps share a database, and while there is some
common set of data that all apps accesses, some applications also have
their own private tables. In this case it is a good idea to have a
separate schema for each application where they can have their private
tables, views, stored procedures etc to evade the disk for collisions.
Now, in SQL 2000, there is a serious restriction in that a schema is
tied to a user. In fact, it makes schema virtually useless. But this
changes in SQL 2005 where users have been separated from schemas.
Finally, the schema in INFROAMTION_SCHEMA is a slightly different
usage. Sometimes uses "schema" to refer some set of tables, possibly
all tables in the database. SQL 2000 even has a CREATE SCHEMA command
for creating several tables in one go.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
好的，所以架构大致类似于Windows中的一个组和桌子有点像用户一样美元？
我想我明白了。感谢您的帮助。
OK, so schema is roughly like a Group in Windows and Tables are
somewhat like Users?
I think I get it. Thanks for the help.
wa *** *****@yahoo.com 写道：
好的，所以架构大致类似于Windows中的一个组，而桌子有点像用户？
我想我明白了。感谢您的帮助。
OK, so schema is roughly like a Group in Windows and Tables are
somewhat like Users?
I think I get it. Thanks for the help.
如果确实如此，SQL Server的工作方式不会尝试将
理解为对任何其他人的理解数据库产品。哇！
-
Daniel A. Morgan
http://www.psoug.org
da ****** @ x.washington.edu
（用你的x代替x）
If that is, indeed, the way SQL Server works do not try to apply
that understanding to any other database product. Whew!
--
Daniel A. Morgan
http://www.psoug.org
da******@x.washington.edu
(replace x with u to respond)
这篇关于架构是什么意思？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
