Defination of "SCHEMA"

Defination of "SCHEMA"

Post by jk.. » Thu, 23 Nov 2000 13:36:19



hey All~

Does anyone know to explain "Schema"?  Give an clear and simple
explaination.  In SQL, schema shows who own the objects.  But in
another website: Schema is the structure of a database system,
described in a formal language supported by the database management
system (DBMS). In a relational database, the schema defines the tables,
the fields in each table, and the relationships between fields and
tables.

Can Anyone help?

best reards,
JK

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 

Defination of "SCHEMA"

Post by Brian Tkat » Sun, 31 Dec 1899 09:00:00



>hey All~

>Does anyone know to explain "Schema"?  Give an clear and simple
>explaination.  In SQL, schema shows who own the objects.  But in
>another website: Schema is the structure of a database system,
>described in a formal language supported by the database management
>system (DBMS). In a relational database, the schema defines the tables,
>the fields in each table, and the relationships between fields and
>tables.

>Can Anyone help?

From Oracle8i Concepts

Schemas and Schema Objects
A schema is a collection of database objects that are available to a
user. Schema objects are the logical structures that directly refer to
the database's data. Schema objects include such structures as tables,
views, sequences, stored procedures, synonyms, indexes, clusters, and
database links. (There is no relationship between a tablespace and a
schema; objects in the same schema can be in different tablespaces,
and a tablespace can hold objects from different schemas.)

HTH,
Brian