+ 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
Often have questions like this?
Learn more efficiently, for free:
