Database Schema Confusion

Question

I have a little terminological criticism when I develop several classes. In Sql Server 2005, “schema” refers to the namespace and organizational system for database objects. But for relational databases in general, “schema” means the DDL design of tables, fields, etc. If I am right about this, it explains a lot of dissonance when I try to read the Microsoft documentation and understand the various access API data. Can you explain what is happening here, is there really a big difference in the definition of a “circuit”?

Answer 1

Yes, the word “schema” is unfortunately overloaded among database providers.

" SQL-99 Complete, Really" :

SQL - ....

SQL - SQL-, ,... , ( ) , . :

• UDT
• SQL-
• , SQL

Oracle "" "" , .

MySQL SCHEMA DATABASE.

PostgreSQL "", " " , SQL "".

Answer 2

. SQL 2005/2008 "" , "" , , , ..