+ 3
What is SCHEMA ?
6 Answers
+ 3
It's a rich snippet:
Schema.org
+ 2
schema is STRUCTURE OF THE TABLE
+ 1
blueprint of the database
+ 1
In Oracle, You can consider that a user is the account you use to connect to a database, and a schema is the set of objects (tables, views, etc.) that belong to that account. According to the way the terminology, a USER and a SCHEMA are somewhat similar. But there is also a major difference. A USER can be called a SCHEMA if the "USER" owns any object, otherwise it will only remain a "USER". Once the USER owns at least one object then by virtue of all of your definitions above... the USER can now be called a SCHEMA.
0
the database
0
other name of TABLE STRUCTURE is SCHEMA