This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

In Database Design Studio, they call such codes as schema. I'm still confused: whether there are two meaning of SCHEMA.

howru(How are you?)

/*
* Target DBMS: 'Ingres'
*/

/*
* Table : eic_level1
* Description :
* id : 12-34567-890 12:Level 890:Sequence Number 34567:Reserved
* name :
* type : Category: 1; Item: 0
* manager :
* email : Manager's E-mail
* manager_notes : Other Information about Manger
* notes :
*/
create table wonme (
id char not null,
name varchar,
type char not null,
manager char not null,
email char not null,
manager_notes char,
notes clob not null,
primary key (id));

(#220742@0)
Last Updated: 2001-10-10
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / IT技术讨论 / Schema's difference. A schema is a collection of database objects like a user. In the meantime, we call .DDL file as a Schema. Maybe one of them wrong or there're some relations between them. tks. -howru(How are you?); 2001-10-4 (#216682@0)

In our company, we call the ERwin file which present all the tables' structure and/or views' as the schema. Oracle have its own definition of Schema. you can get it from their web site. -cyt(cyt); 2001-10-4 (#216968@0)

Hi, cyt. Do you have ERWin4.0? I really need it . Thanks!!! -onewayticket(onewayticket); 2001-10-4 (#216981@0)

Sorry, the most updated ERwin in our company is 3.5. And I only have the copy of 3.0. -cyt(cyt); 2001-10-7 (#218859@0)

www.smiling.com.cn oracle group -frankcheng(frank); 2001-10-10 (#220828@0)

They have moved to www.itpub.net -cyt(cyt); 2001-10-11 (#221623@0)

Try this site. http://surpass.swpi.edu.cn/erwin.htm -cyt(cyt); 2001-10-10 (#220672@0)

That's great! Thanks you all cyt and frankcheng ! -onewayticket(onewayticket); 2001-10-10 (#220901@0)

A schema is a collection of all database objects under a user and the name same as this user. For example: \"select * from scott.emp\\\" The scott is schema not user. -onewayticket(onewayticket); 2001-10-4 (#216974@0)
A Schema represents all database objects (tables, index, views...) of an application. This is what Rational Rose is using. -sailor(Sailor); 2001-10-4 (#216975@0)

In Database Design Studio, they call such codes as schema. I'm still confused: whether there are two meaning of SCHEMA. -howru(How are you?); 2001-10-10 {709} (#220742@0)
/*
* Target DBMS: 'Ingres'
*/

/*
* Table : eic_level1
* Description :
* id : 12-34567-890 12:Level 890:Sequence Number 34567:Reserved
* name :
* type : Category: 1; Item: 0
* manager :
* email : Manager's E-mail
* manager_notes : Other Information about Manger
* notes :
*/
create table wonme (
id char not null,
name varchar,
type char not null,
manager char not null,
email char not null,
manager_notes char,
notes clob not null,
primary key (id));

Actually, Oracle automatically creates a schema when you create a user , the schema name is your user name. All tables, views, indexes and privileges created by this user will belong to this schema. -wander2001(wander); 2001-10-10 {95} (#220820@0)
And if you don't specify, all those objects will be created on default tablespace of this user

@Las Vegas

In Database Design Studio, they call such codes as schema. I'm still confused: whether there are two meaning of SCHEMA.

Replies, comments and Discussions:

More Topics