使用不同的数据库的数据库和模式之间的区别？ [英] Differences between Database and Schema using different databases?

问题描述

MS SQL和MySQL之间的数据库术语有什么区别？

MySQL实例可以有多个数据库吗？它似乎只能创建不同的模式。但是，SQL命令是 create database 。

在MS SQL中，您可以创建多个数据库...每个都有 //msdn.microsoft.com/en-us/library/ms190387.aspxrel =noreferrer>链接，我们看到MS SQL模式不再绑定到用户，这里是相关的报价： p>

在SQL
Server 2005中更改了模式的行为。模式不再是
等效于数据库用户;每个
模式现在是一个不同的命名空间
，它独立于创建它的
数据库用户。在其他
字中，模式只是一个容器
的对象。

在MySQL中，数据库和模式是完全相同的事情，你甚至可以在命令中交换字，即CREATE DATABASE有同义词CREATE SCHEMA。

MySQL支持多个数据库MS SQL支持多个数据库和多个模式。

What are the differences in database terminology between MS SQL and MySQL?

Can a MySQL instance have more than one database? It appears that it can only create different schemas. However, the SQL command is create database.

In MS SQL, you can create multiple databases… each have a default schema of dbo?… but multiple schemas in a database is still possible?

解决方案

From this link, we see that MS SQL schemas are no longer tied to users, here's the relevant quote:

The behavior of schemas changed in SQL Server 2005. Schemas are no longer equivalent to database users; each schema is now a distinct namespace that exists independently of the database user who created it. In other words, a schema is simply a container of objects. A schema can be owned by any user, and its ownership is transferable.

In MySQL, databases and schemas are exactly the same thing, you can even interchange the word in the commands, i.e. CREATE DATABASE has the synonym CREATE SCHEMA.

MySQL supports multiple databases (schemas) and MS SQL supports multiple databases and multiple schemas.

这篇关于使用不同的数据库的数据库和模式之间的区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！