Database ----- introduction to catalog and schema

Source: Internet
Author: User
In the SQL environment, both Catalog and Schema are abstract concepts. They are mainly used to solve naming conflicts. A database system contains multiple Catalog, and each Catalog contains multiple schemas, each Schema contains multiple database objects (tables, views, fields, and so on). For example, the fully qualified names of database object tables can be expressed as Catalog names. schema name. table Name SQL

In the SQL environment, both Catalog and Schema are abstract concepts. They are mainly used to solve naming conflicts. A database system contains multiple Catalog, and each Catalog contains multiple schemas, each Schema contains multiple database objects (tables, views, fields, and so on). For example, the fully qualified names of database object tables can be expressed as Catalog names. schema name. table Name SQL

In the SQL environment, both Catalog and Schema are abstract concepts. They are mainly used to solve naming conflicts.


A database system contains multiple Catalog, and each Catalog contains multiple schemas. Each Schema contains multiple database objects (tables, views, fields, and so on)


For example, the full qualified name of the database object table can be expressed as: Catalog name. Schema name. Table Name


The SQL standard does not require that the fully qualified names of each database object be unique, just like domain names. If you like it, each IP Address can have multiple domain names.


From the perspective of implementation, the support and implementation methods for Catalog and Schema vary widely in various database systems. A simple and common implementation method is to use the database name as the Catalog name, use the username as the Schema name. For details, see the following table:

Supplier

Catalog support

Schema support

Oracle

Not Supported

Oracle User ID

MySQL

Not Supported

Database Name

Ms SQL Server

Database Name

The object owner name, which has changed since version 2005.

DB2

The Catalog part is omitted when the database object is specified.

Catalog owner name

Sybase

Database Name

Database owner name

Informix

Not Supported

No

PointBase

Not Supported

Database Name

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.