×

Loading...
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.

/*
* 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));
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.
    • 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.
      • Hi, cyt. Do you have ERWin4.0? I really need it . Thanks!!!
        • Sorry, the most updated ERwin in our company is 3.5. And I only have the copy of 3.0.
          • www.smiling.com.cn oracle group
            • They have moved to www.itpub.net
        • Try this site. http://surpass.swpi.edu.cn/erwin.htm
          • That's great! Thanks you all cyt and frankcheng !
    • 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.
    • A Schema represents all database objects (tables, index, views...) of an application. This is what Rational Rose is using.
      • In Database Design Studio, they call such codes as schema. I'm still confused: whether there are two meaning of SCHEMA.
        /*
        * 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.
          And if you don't specify, all those objects will be created on default tablespace of this user