什么是schema?
这里只讨论数据库中的schema,而不讨论XML中的schema。在wiki上,这样解释schema:
In a relational database, the schema defines the tables, views, indexes, packages,procedures, functions, queues, triggers, types, sequences, materialized views, synonyms,database links, directories, Java, XML schemas, and other elements.
而实际上,schema就是数据库对象的集合。
我们先来看一下schema的定义:
A schema is a collection of database objects (used by a user.).Schema objects are the logical structures that directly refer to the database’s data.A user is a name defined in the database that can connect to and access objects.schema and users help database administrators manage database security.