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)
2001-10-10 -05:00

回到话题: 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.

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=220742